View Single Post
  #3   Report Post  
OzGhostRiding
 
Posts: n/a
Default

Thanks Frank. Now apart from manually entering each hyperlink, a tedious job
for 1500 links is there a way I can apply that hyperlink to an entire column
so each code links to it's corresponding page?

"Frank Kabel" wrote:

Hi
in B3 enter:
=HYPERLINK("www.website.com/generic/" & A3 & "/" & A3 & ".html",A3)

--
Regards
Frank Kabel
Frankfurt, Germany

"OzGhostRiding" schrieb im
Newsbeitrag ...
I wish to link an excel pricelist to a company website with the

product
descriptions using the product codes listed in column A. There are
approximately 1500 product codes.
example:
Cell a3 has the value 12345
hyperlink is www.website.com/generic/12345/12345.html
and so on down the column.