Contextures

Contextures News 2021-04-20

Excel Reverse Names Formula

April 20, 2021

Reverse names with a formula, Power Query shortcuts, and more, in this week's Excel news. Visit my Excel website for more tips, tutorials and videos, and check the index for past issues of this newsletter.

Thank you for reading the news, and you'll get the next email on May 4th.

Note: For some products mentioned below, I earn a commission on sales. That helps support the free tutorials on my site.

Reverse Names With MID

If names are in Last, First order in an Excel workbook, use a MID formula to reverse them, in another cell. There's a new video on on the Split or Reverse Names page on my Contextures site, that shows how it works.

For example, if cell B2 has this name --Smith, Mary -- put this formula in another cell, to get this result -- Mary Smith

  • =MID(B2&" "&B2,FIND(", ",B2)+2,LEN(B2)-1)

How It Works

  • MID function returns text from a string (Smith, Mary Smith, Mary)
  • FIND function gets the starting position (8)
  • LEN function gives the number of characters to return (10)

currency selection list

There are written steps, a short video, and other ways to split or reverse names. on the Split or Reverse Names page on my Contextures site. And here's the Reverse Names video, that shows the MID formula.

Excel Articles

Here are a few Excel-related links that you might find useful or interesting.

Power Query: On the Excel Campus blog, Jon Acampora shows 15 shortcuts you can use with Power Query. There's a video, written steps, and a sample file. (Level - Int/Adv)

Challenges: On the MrExcel site, Bill Jelen used to run occasional Excel challenges. The latest one is from 8 years ago, but there's still lots to learn by looking through the challenges and solutions. And now that we have spill functions and Power Query, you can find better solutions, I'm sure! (Level - Int/Adv)

Excel: On Twitter, the offical Microsoft Excel account asked how you'd explain Excel to a friend who's never heard of it. How would you answer that question? (Level - All)

Also see: Previous Newsletter Issues

Spring Sky

Last Thursday, I had to go out for an eye doctor appointment, and the weather had taken a turn for the worse. It was a damp and chilly (8 C) day, with a brisk wind, and the sky looked like a scene from of a horror movie.

It's a bit warmer now, but tomorrow's forecast calls for snow! I hope spring weather is back soon.

weekly photo

NOTE: To read this newsletter online, paste this URL into your web browser: https://www.contextures.com/newsletter/excelnews2021/20210420ctx.html
I'll also post any article updates or corrections there.

That's it for this week! If you have any comments or questions, send me an email.

Debra Dalgleish
dsd @contextures.com
ctxdebra @gmail.com

Debra Dalgleish

P.S. You can choose the full Contextures news package (news and occasional special announcements), or basic news package (news only). Click either link to change your option.

contextures newsletter info

 

Last updated: April 20, 2021 12:17 PM