hyperlink fn: dynamically building with URLs w/spec. chars

[Scott Farnsworth]

Someone asked...

Ineed to make a hyperlink in this form:

hypertext("http://www.link.com/"+CellA1+"/end";My web
page)

in other word i build my url with a colum.

And the answer was

Use the HYPERLINK function and & to construct the required
reference.
=HYPERLINK("http://www.link.com/"&A1&"/end",My web page)

This is great, BUT MY problem in using this is that the
URL I am building includes & in the "http://www.link.com/"
and/or "/end" part, and because of that this technique
doesn't work.

Normally, if the technique used above is used as shown you
DO get the contents of cell A1 put into the URL for the
hyperlink. However, when the "http://www.link.com/"
and/or "/end" part has an & in it you do not get the
content of cell A1, but instead you get the text "A1". Any
thoughts? Is there a way to "escape" the &'s to get them
to work?

Here's a sample URL I'm trying to use.

http://money.netscape.cnn.com/chart_quote.jsp?
TickerSymbols=MSFT&time=2&ctype=hloc&show=splits&indicators
=mov_avg_50&compidx=none&x=59&y=11

The text "MSFT" (or "IBM" or "HP" or whatever) is what
would be in cell A1.