You're welcome. Thanks for the feedback.
--
Kevin Vaughn


"Patrick" wrote:

You are the KING!!! Thanks!

"Kevin Vaughn" wrote:

I just tried this and it worked for me:
=HYPERLINK("mailto:"&A2&B2&"@"&C2,A2&B2&"@"&C2)

I put my first name in a2, my last initital (as that is how my email is set
up) in b2 and my domain name in c2.
--
Kevin Vaughn


"Patrick" wrote:

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