Hyperlinks based on cell contents from external sources.

[WisdomT]

Hi,

I have a number of spreadsheets that pull information from an external source. I would like one of the columns to have a hyperlink based on the contents on that cell. For example: row 1 has a value of 12345 in the Cell Number column and has a hyperlink to "http://theintranet/databaseapp/updaterecord.asp?cellno=12345", row 2 the value of 67890 and the hyperlink "http://theintranet/databaseapp/updaterecord.asp?cellno=67890", etc, etc.

After much rooting though help files, and the internet I can't see a way of creating the hyperlink.

Can anyone point me in the right direction.

Thanks,

Steve

 

[GlennUK]

Look at the HYPERLINK cell function.

 

[WisdomT]

Look at the HYPERLINK cell function.

Thanks...that was a bit too easy.