Hyperlinks in excel

[gwhiz921]

Hello,

I am looking for an easier way to create friendly name within hyperlink instead of typing. I'd like A2 to be friendly name for link location without having to type "123". Is there a way I can make the cell value the friendly name instead of text string?

 

[Eric W]

Try:

=HYPERLINK(B2,A2)

 

[Fluff]

Just replace the "123" with the cell reference.

 

[gwhiz921]

Hyperline retruns #Name error

when i correct hyperline to hyperlink, the path shows my downloads folder and not website.

 

[gwhiz921]

Just replace the "123" with the cell reference.

It recognizes cell as text so instead of returning 123, I get A2

 

[Eric W]

Sorry, HYPERLINE was a typo (which I've corrected). HYPERLINK is correct.

Book2
	A	B	C
1	Friendly Name	Link Location	URL
2	123	http:\\www.google.com	123
Sheet7

Cell Formulas
Range	Formula
C2	C2	=HYPERLINK(B2,A2)

It works in my example, as you can see. As far as my suggestion, is there a folder name in A2 instead of "123"? Or are you referring to another sheet? As far as Fluff's suggestion, do you have quotes around the A2 (you shouldn't)?

Edit: also note that you need the HTTP:\\ on your link.

 

[gwhiz921]

thank you!

 

[Eric W]

Glad we could help! Thanks for the feedback.