Hello,

The answer to your quandry (assuming the name are in column A) ...

First Name:
=RIGHT(A1,LEN(A1)-FIND(" ",A1,1)+1)

Last Name:
=LEFT(A1,FIND(",",A1,1)-1)

Although you could do this with one formula:

=RIGHT(A1,LEN(A1)-FIND("
"

HTH

--
Regards,
Zack Barresse, aka firefytr


"JFALK" wrote in
message ...

I have a spreadsheet with a column that contains names. They are all in
this format:

-lastname-, -firstname-
example: WASHINGTON, GEORGE

All the individuals have e-mail addresses based on their names. They
a




It's not really " but I don't want to mention the company
name. How would I set this up in another column? Or, how would I break
apart the names so the first names are in one column and the last name
is in another? I would then be able to combine them with the @email.com
after them. Thanks!


--
JFALK
------------------------------------------------------------------------
JFALK's Profile:
http://www.excelforum.com/member.php...o&userid=24728
View this thread: http://www.excelforum.com/showthread...hreadid=393437