Thread: increment IP address.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
d d is offline
external usenet poster
  
Posts: 1
Default 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
Reply With QuoteReply With Quote