How to separate Smith, John

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

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.
 
P

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)
 
Top