Forum Discussion
Solved
Split data first name & Last Name
Hi All, I have data populating a single cell that is basically First names & Last Names. I need to separate the names into two cells "First Name" & "Last Name". The data appears to consistently sepa...
Be sure to save a backup copy before trying.
Click Data, Text To Columns (dialog box will open).
Select delimited
Select space
Click Finish
The attached file has formulas that split first name and second name into 2 columns but....
This assumes that your data has only TWO names with a space between. If you have a middle name it won't work. You can of course adjust the formulas but it will start to get more complicated.
Hope this will sort most of your problems.
all the best.
Peter