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

See above. I got that far. I got a formula to create the correct email
address, but it is not "clickable." I want excel to automatically hyperlink
the email address, so I don't have to manually create the hyperlink.

"starguy" wrote:


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