creating automatic hyperlinks in a worksheet
 

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

creating automatic hyperlinks in a worksheet
 

One way:

If the parcel number is in A1:

=HYPERLINK("http://sandgate.co.clark.nv.us:8498/servlet/Assessor?instance=pcl2&pa
rcel="&A1,A1)


In article ,
"Patrick" wrote:

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

creating automatic hyperlinks in a worksheet
 

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)

Patrick wrote:

JE ...

thanks for the response, it worked, sort of. If I leave
the second reference "a1" in, the link displays as the 11
digit parcel number, but it doen't work, I get an error
message. If I take it out, the entire web address displays
and it works, but I lose what I really wanted, the parcel
number as the link. I checked it numerous times and it's
in there the way you suggested ... can't understand what I
might be doing wrong. Any other suggestions?

thanks,

Patrick

-----Original Message-----
One way:

If the parcel number is in A1:

=HYPERLINK
("http://sandgate.co.clark.nv.us:8498/servlet/Assessor?
instance=pcl2&pa
rcel="&A1,A1)


In article ,
"Patrick" wrote:

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
.


--

Dave Peterson

creating automatic hyperlinks in a worksheet
 

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.


In article ,
"Patrick" wrote:

thanks for the response, it worked, sort of. If I leave
the second reference "a1" in, the link displays as the 11
digit parcel number, but it doen't work, I get an error
message. If I take it out, the entire web address displays
and it works, but I lose what I really wanted, the parcel
number as the link. I checked it numerous times and it's
in there the way you suggested ... can't understand what I
might be doing wrong. Any other suggestions?