Forgot to mention that there is a limit to the number of characters for the link - about 250. If it is more than 250, it may still show as a link (blue, underline etc.) but nothing happens when you click. However, the example you gave was not above the limit.

It seems to work for me both ways - a true hyperlink or a spec for a hyperlink.

Epinn

"Epinn" wrote in message ...
I used hyperlink function before and I just tried it again. It works fine for me. I use Excel 2003.

See if the following link gives you some inspiration.

http://www.mrexcel.com/archive/Formulas/19517.html

A line from the above link:

"The value in column 2 is exactly a link reference (not a true hyperlink -- rather a spec for a hyperlink)."

Epinn

"Frank B Denman" wrote in message ...
Forgot to mention this is Excel 2k3 SP2
Frank Denman
Denman Systems

[Please delete the "x" from my email address]