Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

up vote 13 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

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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