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.
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
How It Works
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.
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
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.
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.
Last updated: April 20, 2021 12:17 PM