Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
increment IP address.
Hi all,
is it possible to create a formula to increment (only in the last octet) an IP address present in a cell and display it in another cell? if P30 has ip address 192.168.10.1 I need A10 to display 192.168.10.2 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
increment IP address.
Hi,
Am Thu, 18 Apr 2013 08:23:47 -0700 (PDT) schrieb d: is it possible to create a formula to increment (only in the last octet) an IP address present in a cell and display it in another cell? if P30 has ip address 192.168.10.1 I need A10 to display 192.168.10.2 in A10 try: =SUBSTITUTE(P30,TRIM(RIGHT(SUBSTITUTE(P30,".",REPT (" ",255)),255)),TRIM(RIGHT(SUBSTITUTE(P30,".",RE PT(" ",255)),255))+1) Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
increment Address formula | Excel Discussion (Misc queries) | |||
Increment/Increment letter in alphabetical order | Excel Programming | |||
how to make cell address reference increment? | Excel Worksheet Functions | |||
long address list, name-address-city, listed vertically, how do y. | Excel Discussion (Misc queries) | |||
LINKING Address cells from an EXCEL spreadsheet to fill MapQuest Address Info | Excel Programming |