Separating last and first names in a cell

F

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

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

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
 
M

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
Click to expand...
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
 
Top