Excel Forum
Similar Content
Formula to Delete the First or Last Word from a Cell in Excel
Tutorial: Excel formula to delete the first or last word from a cell. You can copy and paste the for...
Filter Data to Show the Top 10 Items from a Data Set in Excel - AutoFilter
Macro: This Excel macro filters data in Excel in order to display the top 10 items from the data ...
Extract the Last Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
Macro: This UDF (user defined function) extracts the last word or characters from a cell in Excel...

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.