Hi!

Consider this:

Marion Ross

Which is the first name and which is the last?

Biff

"data_diva" wrote in
message ...

Hi there,

I am a newbie and am having some trouble with seperating data in
Excel.

Here is my issue:

I have a table of employee names are in one column alone, but all in a
different format:

first name -space- last name
last name, first name
last name -space- first name

What I am needing to do is get all the names to be in the same order
and seperated into two columns as:

Last Name column
First Name column

How do I take those combined name formats that are in one column and
seperate them into seperate columns in the correct order?

Thanks,

Christina


--
data_diva
------------------------------------------------------------------------
data_diva's Profile:
http://www.excelforum.com/member.php...o&userid=28885
View this thread: http://www.excelforum.com/showthread...hreadid=486339