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 |
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 |
All times are GMT +1. The time now is 07:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com