Add Cell Text to end of URL

[Boddo52]

Hi,

I'm wanting to add a hyper-link to a cell, but i need the text from that cell to be at the end of the hyper-link.

Eg. Column A would contain reference numbers, and each reference number points to it's respective link

A1 = a12f345hj6
A2 - asd456gfhj

I want to hyperlink:
cell A1 to Googlea12f345hj6
cell A2 to www.google.com/asd456gfhj

I'm wanting to do this automatically for over 1000 cells - so doing it manually wouldn't be practical.

Any suggestions? Is there a way i can add a formula to do this (Something like =HYPERLINK(Google[cellvalue], "text")

Cheers!

Boddo52

 

[AliGW]

Try using the INDIRECT function.