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