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