View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
egildone egildone is offline
external usenet poster
 
Posts: 3
Default editing a hyperlink

I have a stock symbol MED in A1. In A2 I have inserted the following link:

http://www.investors.com/StockResear...p.aspx?symbol=

I want to concatenate the symbol in A1 into the hyper link in A2 like
shown below so that the link will show the data for the stock symbol MED.

http://www.investors.com/StockResear...spx?symbol=MED

Is this possible?

Example
A1 A2
MED hyperlink

Ed