View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
reloanpro
 
Posts: n/a
Default Creating a hyperlink in column

I am wanting to have Excel link to a website based on values in a column. For
example, 12345678 is the first value in column R:R, or R2. I want Excel to
convert these values to a link to
"http://www.somewhere.com/abscd.asp?addrs=12345678", but I only want to see
12345678 in that column.

Is this possible? Any help you provide is appreciated.