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