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

Get in touch