Between the Sheets — Excel podcast episode 35: Two Ways of Removing Middle Names From A List

In partnership with Experts Exchange.

Excel has a lot of ways to manipulate text, but finding specific characters starting from the end of a text string isn’t one of them. In this episode, we look at two ways to take a column of full names that includes middle names, middle initials and no middle names and return a clean list of first and last names.

Share:

Facebook
Twitter
Pinterest
LinkedIn
On Key

Related Posts

Experts Exchange Adobe Expert (me)

Experts Exchange named me as the leading expert for Adobe Creative Suite. Check out my tutorial on the new artificial intelligence features in Photoshop.

Get in touch