Hi JFALK,

Try this formula:

=TRIM(LEFT(A1,FIND(",",A1)-1))&"."&TRIM(MID(A1,FIND(",",A1)+1,LEN(A1)))&"@ema il.com"

Regards,
KL


"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