Excel Forum



Excel Magic Trick 511: Extract First, Middle, Last Names From Bad Data With Extra Characters


See how to use Find and Replace, Text To Columns, and the function SUBSTITUTE and TRIM to extract First, Middle, Last Names from data that contains extra characters like commas, and dashes.





Got a Question? Ask it Here in the Forum.