Hyperlink To Email Addresses

[Dan190984]

Hi all

I have created a s/s that contains a list of e-mail addresses the issue I have is that these have been created using an & formula so the addresses wont Hyperlink.

EG

Col a - First Name
Column b - .
column c - last name
Column d - @companyname.com

Column e = =a1&b1&c1&d1

How do I make this email addres in e1 a hyperlink?

Thanks

 

[Michael M]

One way...convert them to text
Highlight the list select Edit / Copy
With the list still highlighted select edit / Paste Special and check "Values Only"

 

[anandvarma]

try this

Excel Workbook
	A	B	C	D	E
1	First Name	*.	last name	*@companyname.com	First Name*.last name*@companyname.com
Sheet1

 

[Dan190984]

Spot on thank you.

 

[anandvarma]

Convert the cell into text then use TRIM to delete spaces in the text. Use Hyperlink to create a Hyperlink

 

[Dan190984]

Next problem -

I then have a look up function which is pulling the e-mail address relevent depending on the name selected from a drop down - however this does not hyperlink.

I tried the hyperlink function in front of the vlookup but received "can not open the specified file" can this be done?

 

[Dan190984]

I am now receiving the cannot open the specified file error on every hyperlink just created!

Arghhh

Any help greatly received.

 

[anandvarma]

try this

Excel Workbook
	A	B	C	D	E	F	G
1	First Name	.	last name	@companyname.com	First Name.last [email]name@companyname.com[/email]	fourthname	fourthname.4lastname@4companyname.com
2	second Name	.	2lastname	@2companyname.com	second [email]Name.2lastname@2companyname.com[/email]
3	thirdname	.	3lastname	@3companyname.com	thirdname.3lastname@3companyname.com
4	fourthname	.	4lastname	@4companyname.com	fourthname.4lastname@4companyname.com
Sheet1

#VALUE!

 

[Dan190984]

Thanks - all hyperlinks are created however they error when clicked.

 

[JazzSP8]

Try;

=HYPERLINK("mailto:"&A1&B1&C1&D1)

etc.