Making all cells in a column links?

[Paul1]

Is there a way to convert the data in every cell in a column to a link?
For example, if a cell has numbers 1234567890, is there a way to make
it link to http://www.site.com/page.html?query=123456790 and so that
whatever numbers are in any other cell be linked to
http://www.site.com/page.html?query=whatever-number-is-in-the-cell?
Thanks.

 

[Ardus Petus]

In B1, enter:
=HYPERLINK("http://www.site.com/page.html?query=" & A1)
then copy down

HTH

 

[Paul1]

Is there a way to make it just display the number and not the entire
URL?

 

[Dave Peterson]

=HYPERLINK("http://www.site.com/page.html?query=" & A1,A1)

 

[Paul1]

The cell is showing 0 instead of the numbers.

 

[Peo Sjoblom]

Only if A1 is empty, it will display what's in A1, if A1 is empty at times
you can use


=IF(A1="","",HYPERLINK("http://www.site.com/page.html?query=" & A1,A1))

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey

 

[Paul1]

So how do I put the number into the cell? When I try putting that
function/code into the same cell as the number, Excel corrects it and
makes it this:

=IF(A1="","",HYPERLINK("http://www.site.com/page.html?query=" &
A1,A1))*123456

That cell still shows 0 in it.
However, if I put it in front of the equal sign, it doesn't work
(obviously because the equal sign needs to come first).

 

[Richard]

If I am understanding right. The formula goes in column B and the number
123456 goes in column A. Have you tried this.

 

[Dave Peterson]

The number goes into one cell (say A1) and the formula goes into a different
cell (say B1).

 

[Paul1]

Can it go in the same place? It will put the same number into two place
this way. Thanks for all the help thus far, btw

 

[Dave Peterson]

If you change your formula to:

=HYPERLINK("http://www.site.com/page.html?query=123456","123456")

But I'd just use two columns (A and B) and then hide column A when I didn't want
to see it anymore.

 

[Paul1]

That worked. Thanks.