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=...s-in-the-cell? Thanks.

[Ardus Petus]

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

HTH
--
AP

"Paul1" <[email protected]> a écrit dans le
message de news: [email protected]...
>
> 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=...s-in-the-cell?
> Thanks.
>
>
> --
> Paul1
> ------------------------------------------------------------------------
> Paul1's Profile:
> http://www.excelforum.com/member.php...o&userid=34428
> View this thread: http://www.excelforum.com/showthread...hreadid=541945
>

[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 wrote:
>
> Is there a way to make it just display the number and not the entire
> URL?
>
> --
> Paul1
> ------------------------------------------------------------------------
> Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428
> View this thread: http://www.excelforum.com/showthread...hreadid=541945

--

Dave Peterson

[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" <[email protected]> wrote in
message news:[email protected]...
>
> The cell is showing 0 instead of the numbers.
>
>
> --
> Paul1
> ------------------------------------------------------------------------
> Paul1's Profile:
> http://www.excelforum.com/member.php...o&userid=34428
> View this thread: http://www.excelforum.com/showthread...hreadid=541945
>

[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.
--
Richard


"Paul1" wrote:

>
> 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).
>
>
> --
> Paul1
> ------------------------------------------------------------------------
> Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428
> View this thread: http://www.excelforum.com/showthread...hreadid=541945
>
>

[Dave Peterson]

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



Paul1 wrote:
>
> 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).
>
> --
> Paul1
> ------------------------------------------------------------------------
> Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428
> View this thread: http://www.excelforum.com/showthread...hreadid=541945

--

Dave Peterson

[Paul1]

Can it go in the same place? It will put the same number into two places 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 wrote:
>
> Can it go in the same place? It will put the same number into two places
> this way. Thanks for all the help thus far, btw.
>
> --
> Paul1
> ------------------------------------------------------------------------
> Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428
> View this thread: http://www.excelforum.com/showthread...hreadid=541945

--

Dave Peterson

[Paul1]

That worked. Thanks.