Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
up vote 14 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")
share|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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .