View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jeffreyj
 
Posts: n/a
Default How do create a formula to add IP addresses?

I am trying to make a formula that adds the last part of an IP address, such
that when I type in one IP address suchas 147.202.70.132, they automatically
fill in below sequentially with 133, 134, 135, etc. Can anyone help me with
this? Thanks.