If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Referencing data from one cell within the text of another
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. |
#3
|
|||
|
|||
Referencing data from one cell within the text of another
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. |
#4
|
|||
|
|||
Referencing data from one cell within the text of another
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. |
Thread Tools | |
Display Modes | |
|
|