increment IP address.

D

d

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
 
C

Claus Busch

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top