Pull text from one cell into formula in a differenet cell

Cell A1 contains only text - a 3 letter stock symbol, say IBM
Cell A2 has a formula for real time data exchange with my broker that returns the current (LAST) stock price: =RTD("tos.rtd", , "LAST", "IBM")

Instead of having to type the letters IBM in the formula, I would like the formula to get this text from cell A1 that contains it. Then if I change the contents of cell A! to a different stock symbol, say GM (General Motors) the formula will show the last price for GM

Try

=RTD("tos.rtd", , "LAST", A1)

Please Login or Register  to view this content.

Thanks - that did it. I thought I needed the quotes around A1 but that's what screwed it up

You're welcome.