View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ross Culver[_2_] Ross Culver[_2_] is offline
external usenet poster
 
Posts: 24
Default How do I do this?

Just concatenate the constant with the cell value.

Ross


"Big UT Fan" wrote in message
...
I'd like to take the values (numbers) in a particular column to a
hyperlink
in which the number is part of the url. For example, imagine a col of 5
digit #s. In cell A:2 is 12345. I want to change this to a hyperlink to
the
url http://www.url.com/id=12345. There has to be a way but I've never done
it. Thanks!