How to separate Smith, John
 

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!

How to separate Smith, John
 

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.

--
Kevin Smith :o)


"FairPlayFL" wrote:

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!

How to separate Smith, John
 

Hi FairPlayFL,

A1: Smith, John


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

--
If this post helps click Yes
---------------
Peggy Shepard


"FairPlayFL" wrote:

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!