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!