How to separate Smith, John

  • Thread starter Thread starter FairPlayFL
  • Start date Start date
F

FairPlayFL

How do I separate First name and Last name in a spread sheet that currently
has both in one colum (Smith, John). I am NOT good with Excel, help!
 
Hello,
if they are all in the same format i.e. Surname, first name

select all of the cells where the names are and then on the Menu Bar click on
Data-->Text to Columns
select Delimited-->Next-->Finish

Tick the Comma option and select Next

the names should now be split.
 
Hi FairPlayFL,

A1: Smith, John


"John" =MID(A1,FIND(",",A1,1)+2,LEN(A1)-FIND(",",A1,1))
"Smith" =LEFT(A1,FIND(",",A1,1)-1)
 
Back
Top