Referencing data from one cell within the text of another

J

J.F.

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?Ge...iew=DetailedPrices&Language=en&QuoteSymbol_1=".

The end result of this would be (as a hyperlink):
http://www.tsx.ca/HttpController?Ge...w=DetailedPrices&Language=en&QuoteSymbol_1=TA

Any ideas? Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Is there a way to get a portion of a WEB 7
Clicking Cell Link Changes Cell on Another Sheet 1
copying data from one cell to another in a workbook in Excel 2003 7
How do I transfer data from one worksheet to another? (Excel 2003) 0
Extract URL from Link Cell / Convert imported text links to hyperl 3
Find Text within a cell 5
Listing Text From Separate Cells into One Cell 2
Add text to begining of cells within a range based on specified criteria 5

Top