up vote 7 down vote favorite
1
share [g+] share [fb]

After years of not wanting Word and Excel to automatically turn things into hyperlinks, the one time I want them to they refuse.

I have a list of strings in Excel which I am concatenating with a string to create a URL, I would like the resulting URL to be a clickable hyperlink but Excel won't play ball. Is this possible?

link|improve this question
50% accept rate
feedback

1 Answer

up vote 12 down vote accepted

Take a look at Hyperlink worksheet function.

Creates a shortcut or jump that opens a document stored on a network server, an intranet, or the Internet. When you click the cell that contains the HYPERLINK function, Microsoft Excel opens the file stored at link_location.

Syntax

HYPERLINK(link_location,friendly_name)

For example:

=HYPERLINK(B1, "Click for report")
link|improve this answer
Great thanks. Better than what I wanted – Jeremy French Nov 5 '09 at 12:35
You're welcome. – Mehper C. Palavuzlar Nov 5 '09 at 12:37
When not using Internet Explorer as your default browser and you ever find some links that don't work as expected, then read about how Office uses "Microsoft Office Protocol Discovery" and the odd "User-Agent: Microsoft Office Existence Discovery" at superuser.com/questions/41935/… – Arjan Nov 5 '09 at 13:01
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.