View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
starguy starguy is offline
external usenet poster
 
Posts: 1
Default How can I combine cells with first/last names into email addy?


solution cannot be provided because you have not put data and respective
cells. however i suppose your data as
col A contains First name
col B contains Last name
col C contains Domain

now to join all these three to make a useable email address put
following funtions in col D and copy down.
=A1&B1&"@"&C1

hope this would serve your purpose.

Patrick Wrote:
I need to combine a first name with last name, combine them with a
domain to
create a useable email address.



--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=573025