Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
increment IP address.
435 views
Skip to first unread message
d
Apr 18, 2013, 11:23:47 AM4/18/13
to
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
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
Claus Busch
Apr 18, 2013, 11:43:49 AM4/18/13
to
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,".",REPT(" ",255)),255))+1)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
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
=SUBSTITUTE(P30,TRIM(RIGHT(SUBSTITUTE(P30,".",REPT("
",255)),255)),TRIM(RIGHT(SUBSTITUTE(P30,".",REPT(" ",255)),255))+1)
Regards
Claus Busch
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2
0 new messages