separating data into multiple columns
 

I have a spreadsheet that lists people in the format LastName,
FirstName. I want to create a formula that will put the last name in
one column and the first in a different column. Can someone please
point me in the right direction? Any help would be greatly
appreciated.

Asa Reynolds


--
AsaReynolds
------------------------------------------------------------------------
AsaReynolds's Profile: http://www.excelforum.com/member.php...o&userid=37842
View this thread: http://www.excelforum.com/showthread...hreadid=573960

separating data into multiple columns
 

AsaReynolds, have a look here

http://www.cpearson.com/excel/FirstLast.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"AsaReynolds"
wrote in message
...

I have a spreadsheet that lists people in the format LastName,
FirstName. I want to create a formula that will put the last name in
one column and the first in a different column. Can someone please
point me in the right direction? Any help would be greatly
appreciated.

Asa Reynolds


--
AsaReynolds
------------------------------------------------------------------------
AsaReynolds's Profile:
http://www.excelforum.com/member.php...o&userid=37842
View this thread: http://www.excelforum.com/showthread...hreadid=573960