| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
column redirect
I have a spreadsheet that has a coulmn of ip addresses. I want to know if
there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? |
|
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
column redirect
How about a formula like:
=HYPERLINK("telnet:\\"&A1) (with A1 containing the ip address. Then drag down the column.) (It opened up a telnet window in my test.) kjs wrote: I have a spreadsheet that has a coulmn of ip addresses. I want to know if there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
column redirect
I'm a novice at this...how do i get this working?
"Dave Peterson" wrote: How about a formula like: =HYPERLINK("telnet:\\"&A1) (with A1 containing the ip address. Then drag down the column.) (It opened up a telnet window in my test.) kjs wrote: I have a spreadsheet that has a coulmn of ip addresses. I want to know if there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? -- Dave Peterson |
|
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
|
column redirect
What is the address of the top cell containing the ip address?
Say it's A1. Then insert a new column B. Then put this in B1. =HYPERLINK("telnet:\\"&A1) Test it to see if it works by clicking on the resulting hyperlink. If it does, then use the techniques described by Debra Dalgleish: http://www.contextures.com/xlDataEntry01.html to fill the cells underneath that first cell with the formula. kjs wrote: I'm a novice at this...how do i get this working? "Dave Peterson" wrote: How about a formula like: =HYPERLINK("telnet:\\"&A1) (with A1 containing the ip address. Then drag down the column.) (It opened up a telnet window in my test.) kjs wrote: I have a spreadsheet that has a coulmn of ip addresses. I want to know if there is a way to config this column so that when I click on a particular ip address in a cell, I will be able to telnet to that Ip address...is this possible? -- Dave Peterson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Stock data manipulation | Excel Worksheet Functions | |||
| Column picked randomly with probability relative to number of entr | Excel Worksheet Functions | |||
| Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Return Count for LAST NonBlank Cell in each Row | Excel Worksheet Functions | |||
Linear Mode
