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.

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

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!