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.