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
Be sure to save a backup copy before trying.
Click Data, Text To Columns (dialog box will open).
Select delimited
Select space
Click Finish