How to separate Smith, John

[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!

 

[Kevin Smith]

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.

 

[pshepard]

Hi FairPlayFL,

A1: Smith, John


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