incorporating value of cell into hyperlink

Hi,
I am having difficultly automating hyperlink insertion into a
spreadsheet. I need the value of the individual cell to be
incorporated
into associated the hyperlink.
Example:
Cell A1 has the value H3001A02-5. The hyperlink(formula?) for this
cell needs to be:
=HYPERLINK("http://lgsun.grc.nia.nih.gov/cgi-bin/pro3?sname=H3001A02-5&val=1","H3001A02-5")

So the value of the cell is embedded into the web address.
I have 15,000 entries in a columns of a spreadsheet, which I want to
be able to associate hyperlinks to, like the example above.
So I need to be able to get excel to automatically construct the
hyperlinks for the other 14999 cells (incorporating the unique cell
values)

Thanks in advance for any advice/ assistance
Kat

Hi
=HYPERLINK("http://lgsun.grc.nia.nih.gov/cgi-bin/pro3?sname=" & A1 &
"&val=1",A1)


--
Regards
Frank Kabel
Frankfurt, Germany

"Kat" schrieb im Newsbeitrag
om...
Hi,
I am having difficultly automating hyperlink insertion into a
spreadsheet. I need the value of the individual cell to be
incorporated
into associated the hyperlink.
Example:
Cell A1 has the value H3001A02-5. The hyperlink(formula?) for this
cell needs to be:

=HYPERLINK("http://lgsun.grc.nia.nih.gov/cgi-bin/pro3?sname=H3001A02-5&
val=1","H3001A02-5")

So the value of the cell is embedded into the web address.
I have 15,000 entries in a columns of a spreadsheet, which I want to
be able to associate hyperlinks to, like the example above.
So I need to be able to get excel to automatically construct the
hyperlinks for the other 14999 cells (incorporating the unique cell
values)

Thanks in advance for any advice/ assistance
Kat

Thanks Frank,
To get the formular you gave me to work I have to make the link in
another column. If I try and make the link witin the cell I am
interested in- ie A1, it says it is a circular function and will not
me allow me to do it.

Is it just not possible to do without making another column?

K

Hi
that's true. It is not possible to have a formula and a value in the
same cell. So either use this helper column or you'll have to use VBA

--
Regards
Frank Kabel
Frankfurt, Germany


Kat wrote:
Thanks Frank,
To get the formular you gave me to work I have to make the link in
another column. If I try and make the link witin the cell I am
interested in- ie A1, it says it is a circular function and will not
me allow me to do it.

Is it just not possible to do without making another column?

K