Hello ...

I have somewhat of a unique problem. I have a worksheet
with various records in rows that have a unique
identifier. This identifier is an 11 digit number that
when coupled with a set web address, will go directly to
the record I want to view from the speadsheet. Example
below

http://sandgate.co.clark.nv.us:8498/servlet/Assessor?
instance=pcl2&parcel=16412716020

(16412716020 is the unique number in each row of the
worksheet)

I would like to join the unique number with the web
address so that when records are imported to the
worksheet, the link to the webpage is automatically
created. I can join the web address and the number into
one cell, however I want to know if there's a method of
automatically converting the joined cell into a hyperlink?

Any help or direction appreciated,

thanks,

Patrick