How can I combine cells with first/last names into email addy?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Patrick - 18 Aug 2006 13:19 GMT

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

Reply to this Message

Gary''s Student - 18 Aug 2006 13:42 GMT

if the names are in A1 and B1, use:

=A1 & "." & B1 & "@somewhere.com"

Signature

Gary's Student

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

Reply to this Message

Patrick - 18 Aug 2006 13:46 GMT

Yes, I got that far, but I want Excel to hyperlink it automatically to create
a "clickable" email address.

> if the names are in A1 and B1, use:
>
> =A1 & "." & B1 & "@somewhere.com"
>
> > I need to combine a first name with last name, combine them with a domain to
> > create a useable email address.

Reply to this Message

Patrick - 18 Aug 2006 13:50 GMT

I was thinking I could possibly populate another column with the results, but
don't know if that's possible; i.e. have the formula calculate the email
address, then send it to a cell as a value only.

> Yes, I got that far, but I want Excel to hyperlink it automatically to create
> a "clickable" email address.
[quoted text clipped - 5 lines]
> > > I need to combine a first name with last name, combine them with a domain to
> > > create a useable email address.

Reply to this Message

starguy - 18 Aug 2006 14:02 GMT

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.

Signature

starguy

Reply to this Message

Patrick - 18 Aug 2006 14:14 GMT

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.

> solution cannot be provided because you have not put data and respective
> cells. however i suppose your data as
[quoted text clipped - 12 lines]
> > domain to
> > create a useable email address.

Reply to this Message

starguy - 18 Aug 2006 14:37 GMT

i dont think there is a way to do this through formulas
however you can do this with a little manual work
copy the column which contains formula (say col D) and right click on
cell E1, select paste special and check values then Ok.
now click on cell E1 and press F2 then enter (this will turn email into
hyperlink), repeat this for cell E2, E3 and so on... this means you have
to press F2 and then Enter for all cells down.

hope this would help.

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
[quoted text clipped - 27 lines]
> > View this thread:
> http://www.excelforum.com/showthread.php?threadid=573025

Signature

starguy

Reply to this Message

Kevin Vaughn - 18 Aug 2006 17:43 GMT

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.

Signature

Kevin Vaughn

> 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
[quoted text clipped - 16 lines]
> > > domain to
> > > create a useable email address.

Reply to this Message

Patrick - 18 Aug 2006 17:46 GMT

You are the KING!!! Thanks!

> I just tried this and it worked for me:
> =HYPERLINK("mailto:"&A2&B2&"@"&C2,A2&B2&"@"&C2)
[quoted text clipped - 22 lines]
> > > > domain to
> > > > create a useable email address.

Reply to this Message

Kevin Vaughn - 18 Aug 2006 18:41 GMT

You're welcome. Thanks for the feedback.

Signature

Kevin Vaughn

> You are the KING!!! Thanks!
>
[quoted text clipped - 24 lines]
> > > > > domain to
> > > > > create a useable email address.

Reply to this Message