| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- Paul1 ------------------------------------------------------------------------ Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428 View this thread: http://www.excelforum.com/showthread...hreadid=541945 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making all cells in a column links?
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making all cells in a column links?
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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" wrote in message ... 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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making all cells in a column links?
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making all cells in a column links?
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 |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Making all cells in a column links?
That worked. Thanks. -- Paul1 ------------------------------------------------------------------------ Paul1's Profile: http://www.excelforum.com/member.php...o&userid=34428 View this thread: http://www.excelforum.com/showthread...hreadid=541945 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format as a MACRO | Excel Worksheet Functions | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Count Position of Filtered TEXT cells in a column | Excel Worksheet Functions | |||
| Comparing Cells and Displaying Data | Excel Worksheet Functions | |||
Linear Mode
