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.


On Key

Related Posts

Excel 365 for Busy People

Are you short on time and need to learn or brush up on intermediate and advanced Excel? Check out my course, “Excel 365 for Busy

Get in touch