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

Now certified in AI Ethics

Just earned my third AI certification: AI+ Ethics, from AI Certs. Now offering training in ethics issues, including transparency, accountability, privacy, mitigating bias and compliance

Earned another AI certification

I just earned the AI+ Executive certification from AI Certs. This is to assist and train companies in developing AI strategies, governance and risk management,

Get in touch

AI Workshop Inquiry/Booking