Thank you for dropping by. It is a good suggestion.

I am as baffled as Frank mainly because he got the balloon and no error message.

when the mouse pointer hovers over my non-functional hyperlinks, the
pointer changes to the expected hand with index finger extended, and the balloon
message "http://somedomain.com - Click once to follow. Click and hold to select
this cell" appears as expected. <<

As I pointed out previously CHAR(7) had no negative impact and blanks gave #VALUE. Today I tried CHAR(34) and CHAR(160) and they gave the error "the address of this site is not valid ......" Wonder what other CHAR() we can try - something deceiving.

I am writing to share my experience. I recall something *similar* happened to me a few weeks ago. I clicked on a *true* hperlink (blue, underline) in a cell on an Excel worksheet and nothing popped up and no error message. So I thought it didn't work. However, when I clicked on Internet Explorer (already opened) on the task bar (at the very bottom of the screen), the web site was actually displayed. I clicked on the hyperlink four times and I had four sessions of the web site displayed. So, it actually worked despite no popping up. Last night, a pop up happened when I clicked on a hyperlink. I didn't change any Excel settings in between. I did do some cleanup e.g. cache.

Any insight to this?

Wonder if Frank had the browser opened before he clicked on the hyperlink.

Just a thought.

Epinn




"Gary''s Student" wrote in message ...
try:

=HYPERLINK(TRIM(SUBSTITUTE(SUBSTITUTE(E2,CHAR(34), ""),CHAR(160),"")))

--
Gary's Student
gsnu200703


"Frank B Denman" wrote:

This has me baffled and I would greatly appreciate some help.

Column E contains URLs, and I'm trying to use the hyperlink function to create
hyperlinks in column F.

For example:

Cell E2 contains the url "http://www.somedomain.com". (My newsreader is
automatically making this a hotlink, but in Excel it is plain text.)

Cell F2 contains the formula "=hyperlink(E2)" and the result looks just like a
good hyperlink. It's blue and underlined. But nothing at all happens when I
click it. Neither a jump nor an error message. Same result if the formula is
"=hyperlink(E2,E2)".

Am I overlooking something really simple?

TIA

Frank

Frank Denman
Denman Systems

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