creating automatic hyperlinks in a worksheet

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

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
 
I tried J.E.'s formula and it worked ok for me (I used the same parcel that you
and J.E. had in you posts).

Any chance you enter the parcel as numbers and need a special format passed to
the web page?

(I tried 1234123 (random digits) and the web site yelled at me:
Parcel Number should be of form 999-99-999-999.

So, maybe a slight modification to J.E.'s formula:

=HYPERLINK("http://sandgate.co.clark.nv.us:8498/servlet/Assessor?instance=pcl2
&parcel="&TEXT(A1,"000-00-000-000"),TEXT(A1,"000-00-000-000"))

(all in one cell)
 
Well, the server is kind of flakey - I'm getting a timeout about one
time in three.

Otherwise, no - no suggestions, since it works for me as is. I'll
send a file to you with my test sheet.
 
Back
Top