+ Reply to Thread
Results 1 to 12 of 12

Making all cells in a column links?

  1. #1
    Registered User
    Join Date
    05-14-2006
    Posts
    6

    Making all cells in a column links?

    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.

  2. #2
    Ardus Petus
    Guest

    Re: Making all cells in a column links?

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

    HTH
    --
    AP

    "Paul1" <Paul1.27t57a_1147627200.4775@excelforum-nospam.com> a écrit dans le
    message de news: Paul1.27t57a_1147627200.4775@excelforum-nospam.com...
    >
    > 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
    >




  3. #3
    Registered User
    Join Date
    05-14-2006
    Posts
    6
    Is there a way to make it just display the number and not the entire URL?

  4. #4
    Dave Peterson
    Guest

    Re: Making all cells in a column links?

    =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

  5. #5
    Registered User
    Join Date
    05-14-2006
    Posts
    6
    The cell is showing 0 instead of the numbers.

  6. #6
    Peo Sjoblom
    Guest

    Re: Making all cells in a column links?

    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" <Paul1.27t9dd_1147632608.4587@excelforum-nospam.com> wrote in
    message news:Paul1.27t9dd_1147632608.4587@excelforum-nospam.com...
    >
    > 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
    >




  7. #7
    Registered User
    Join Date
    05-14-2006
    Posts
    6
    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).

  8. #8
    Richard
    Guest

    Re: Making all cells in a column links?

    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
    >
    >


  9. #9
    Dave Peterson
    Guest

    Re: Making all cells in a column links?

    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

  10. #10
    Registered User
    Join Date
    05-14-2006
    Posts
    6
    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.

  11. #11
    Dave Peterson
    Guest

    Re: Making all cells in a column links?

    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

  12. #12
    Registered User
    Join Date
    05-14-2006
    Posts
    6
    That worked. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1