inserting cell data into a hyperlink

[jdupuy3]

On Sheet 2 of my workbook, there is a cell for the user to enter thei
Zip Code. This Zip Code is needed for part of a hyperlink on Sheet 1.

For example, if the Zip Code entered was 90210, the hyperlink would b
www.internet.com/90210 . Is there a way to mesh entered text and
hyperlink like this?

Thanks,
Jaso

 

[Frank Kabel]

Hi Jason
try something like
=HYPERLINK(www.internet.com/ & 'sheet2'!A1)

 

[Dave Peterson]

How about a worksheet formula:

=hyperlink("http://www.internet.com/" & text(sheet2!A1,"00000"))

 

[jdupuy3]

nevermind i got it, although it probably isn't the most gracefu
solution.

for anyone interested to do the example above, i would have entere
www.internet.com/ into A1 and 90210 in A2.

In A3, i would enter the formula concatenate(A1,A2) to merge the th
two data sources.

In A4, i would enter the formula hyperlink(A3, "Text")

Not graceful, but the job gets don

 

[Earl Kiosterud]

Jason,

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:="www.internet.com/" &
ActiveCell