Forum Discussion
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 separated by a space between the two names. Is there a formula that will split the two into separate cells based on encountering a "space" . Ant help would be appreciated.
Be sure to save a backup copy before trying.
Click Data, Text To Columns (dialog box will open).
Select delimited
Select space
Click Finish
2 Replies
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
Be sure to save a backup copy before trying.
Click Data, Text To Columns (dialog box will open).
Select delimited
Select space
Click Finish
