Separating last and first names in a cell

[Fury]

Hi,

I was given a report in which the each cell in the first column is se
up as Last Name, First Name. I need to split it so that Last name i
in column A, and the first name is in Column B. It can be don
manually..but.. i'm sure that there has to be a formula that can d
this.


Thanks!

 

[Arvi Laanemets]

Hi

Be sure there is an empty column (B:B) next to one with names (A:A)

Select the range with names
From menu, select Data.TextToColumns, set delimiter to space + comma, or to
Custom ", " (for case you have multiple-part first or last names), and
finish.

 

[theillknight]

The easiest way I can think of is to highlight the column with th
names. Then, go to Data - Text to Columns, select Delimited, the
check the 'comma' box

 

[Fury]

Thank You guys~!!

 

[Mark K.]

-----Original Message-----
I was given a report in which the each cell in the first column is set
up as Last Name, First Name. I need to split it so that Last name is
in column A, and the first name is in Column B. It can be done
manually..but.. i'm sure that there has to be a formula

that can dothis.

Try NameParser - does the trick with difficult names in
Excel that 'Text-to-columns' can't handle.
http://www.infoplan.com.au/nameparser

- Mark