Thanks for taking the time to read and hopefully help me come up with a
solution...

Cell A1 = 1234

cell A2 =hyperlink("http://www.website.com/" & "A1" & ".aspx","name to
appear in speadsheet cell A2") where A1 needs to be "1234" the value of cell
A1

so the hyperlink I am wanting is "http://www.website.com/1234.aspx"

For some reason I can not get the "1234" to get in there by clicking on A1
while imputing the code.