Referencing data from one cell within the text of another

I am looking for a way to reference data from one cell to be used in the text of another seperate cell. This is for the purpose of looking up stock tickers, where I want to be able to put in the ticker itself (usually a 2 or 3 letter stock ticker) and then have it placed automatically into a web address (hyperlinked) in a seperate cell. For example, I want to be able to place "TA" in one cell (without quotations, of course) and in another cell have it placed at the end of the following web address: "http://www.tsx.ca/HttpController?GetPage=QuotesViewPage&DetailedView =DetailedPrices&Language=en&QuoteSymbol_1=".

The end result of this would be (as a hyperlink):
http://www.tsx.ca/HttpController?Get...oteSymbol_1=TA

Any ideas? Thanks.

Hi
try
=HYPERLINK(http://www.tsx.ca/HttpController?Get...sViewPage&Deta
iledView=DetailedPrices&Language=en&QuoteSymbol_1= & A1,A1)


--
Regards
Frank Kabel
Frankfurt, Germany


J.F. wrote:
I am looking for a way to reference data from one cell to be used in
the text of another seperate cell. This is for the purpose of
looking up stock tickers, where I want to be able to put in the
ticker itself (usually a 2 or 3 letter stock ticker) and then have it
placed automatically into a web address (hyperlinked) in a seperate
cell. For example, I want to be able to place "TA" in one cell
(without quotations, of course) and in another cell have it placed at
the end of the following web address:

"http://www.tsx.ca/HttpController?GetPage=QuotesViewPage&DetailedView =D
etailedPrices&Language=en&QuoteSymbol_1=".

The end result of this would be (as a hyperlink):

http://www.tsx.ca/HttpController?Get...ailedView =De
tailedPrices&Language=en&QuoteSymbol_1=TA

Any ideas? Thanks.

Using that gives me an "invalid formula" error, originating at the & ...

"Frank Kabel" wrote:

Hi
try
=HYPERLINK(http://www.tsx.ca/HttpController?Get...sViewPage&Deta
iledView=DetailedPrices&Language=en&QuoteSymbol_1= & A1,A1)


--
Regards
Frank Kabel
Frankfurt, Germany


J.F. wrote:
I am looking for a way to reference data from one cell to be used in
the text of another seperate cell. This is for the purpose of
looking up stock tickers, where I want to be able to put in the
ticker itself (usually a 2 or 3 letter stock ticker) and then have it
placed automatically into a web address (hyperlinked) in a seperate
cell. For example, I want to be able to place "TA" in one cell
(without quotations, of course) and in another cell have it placed at
the end of the following web address:

"http://www.tsx.ca/HttpController?GetPage=QuotesViewPage&DetailedView =D
etailedPrices&Language=en&QuoteSymbol_1=".

The end result of this would be (as a hyperlink):

http://www.tsx.ca/HttpController?Get...ailedView =De
tailedPrices&Language=en&QuoteSymbol_1=TA

Any ideas? Thanks.

Hi
sorry, a typo. Use:
=HYPERLINK(http://www.tsx.ca/HttpController?Get...sViewPage&Deta
iledView=DetailedPrices&Language=en&QuoteSymbol_1= " & A1,A1)

--
Regards
Frank Kabel
Frankfurt, Germany


J.F. wrote:
Using that gives me an "invalid formula" error, originating at the &
...

"Frank Kabel" wrote:

Hi
try

=HYPERLINK(http://www.tsx.ca/HttpController?Get...sViewPage&Deta
iledView=DetailedPrices&Language=en&QuoteSymbol_1= & A1,A1)


--
Regards
Frank Kabel
Frankfurt, Germany


J.F. wrote:
I am looking for a way to reference data from one cell to be used
in
the text of another seperate cell. This is for the purpose of
looking up stock tickers, where I want to be able to put in the
ticker itself (usually a 2 or 3 letter stock ticker) and then have
it placed automatically into a web address (hyperlinked) in a
seperate cell. For example, I want to be able to place "TA" in one
cell (without quotations, of course) and in another cell have it
placed at the end of the following web address:


"http://www.tsx.ca/HttpController?GetPage=QuotesViewPage&DetailedView =D
etailedPrices&Language=en&QuoteSymbol_1=".

The end result of this would be (as a hyperlink):


http://www.tsx.ca/HttpController?Get...ailedView =De
tailedPrices&Language=en&QuoteSymbol_1=TA

Any ideas? Thanks.