need surnames in a column in excel seperate from the first names

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

If I have a column containing both first name and surnames, how do I get the
surnames into another column?
 
Another way using formulas, assuming you have the names in A1 and they all
have the first name first and are separated by a space,
=LEFT(A1,FIND(" ",A1)-1)
for the first name,
=RIGHT(A1,LEN(A1)-FIND(" ",A1))
for the second name.
Copy > Paste special > Values to lose the formulas.
These can go in any cell rather than having to have columns B and C empty as
is necessary using Text to Columns. If Columns B and C are empty and
available, Text to Columns is the easier option.
Regards,
Alan.
 
Back
Top