software

Hello Everyone,

Is this possible with the Hyperlink formula, I want to hyperlink to
moneycentral.msn.com/investor...g.asp?Symbol=a

but on the Symbol=A, I want that A to actually be a cell say A1 where A will
be in that cell.

Is that possible.

Try something like this:

=HYPERLINK(quot;moneycentral.msn.com/investor/charts/charting.asp?Symbol=quot;amp;A1,quot;MyStockquot;)

Does that help?

***********
Regards,
Ron

XL2002, WinXP-Proquot;JavyDquot; wrote:

gt; Hello Everyone,
gt;
gt; Is this possible with the Hyperlink formula, I want to hyperlink to
gt; moneycentral.msn.com/investor...g.asp?Symbol=a
gt;
gt; but on the Symbol=A, I want that A to actually be a cell say A1 where A will
gt; be in that cell.
gt;
gt; Is that possible.

Not quite Ron, takes me to the web page but stays stuck on the symbol entry,
it's waiting for input, I need it to pick up the ticker in the cell and open
the page with the ticker already in it. You know what I mean.

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; =HYPERLINK(quot;moneycentral.msn.com/investor/charts/charting.asp?Symbol=quot;amp;A1,quot;MyStockquot;)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;JavyDquot; wrote:
gt;
gt; gt; Hello Everyone,
gt; gt;
gt; gt; Is this possible with the Hyperlink formula, I want to hyperlink to
gt; gt; moneycentral.msn.com/investor...g.asp?Symbol=a
gt; gt;
gt; gt; but on the Symbol=A, I want that A to actually be a cell say A1 where A will
gt; gt; be in that cell.
gt; gt;
gt; gt; Is that possible.

This is what I used

=HYPERLINK(CONCATENATE(quot;moneycentral.msn.com/investor/charts/charting.asp?Symbol=quot;,A1),A1)

Thanks for your help. I can't beleive I answered my own questions. LOL

quot;Ron Coderrequot; wrote:

gt; Try something like this:
gt;
gt; =HYPERLINK(quot;moneycentral.msn.com/investor/charts/charting.asp?Symbol=quot;amp;A1,quot;MyStockquot;)
gt;
gt; Does that help?
gt;
gt; ***********
gt; Regards,
gt; Ron
gt;
gt; XL2002, WinXP-Pro
gt;
gt;
gt; quot;JavyDquot; wrote:
gt;
gt; gt; Hello Everyone,
gt; gt;
gt; gt; Is this possible with the Hyperlink formula, I want to hyperlink to
gt; gt; moneycentral.msn.com/investor...g.asp?Symbol=a
gt; gt;
gt; gt; but on the Symbol=A, I want that A to actually be a cell say A1 where A will
gt; gt; be in that cell.
gt; gt;
gt; gt; Is that possible.