Excel incrementing IP addresses

[Robertson1995]

I have a spreadsheet that contains numerous IP addresses. What I need is if I have for example 10.125.190.55 in Cell A1, in Cell D1 in need this IP address plus 1 which would be 10.125.190.56. Its not recognizing it in the IP format. Is this a formatting issue or is there a formula to make this work?

 

[hikerguy]

It substitutes the . in the IP address with 255 spaces. Then uses the RIGHT function to return the rightmost 255 characters from the substituted value. Trim is then used to remove excess spaces.

Hi VoG, I'm still not understanding why you need to insert a number of spaces, but I went another route. I ended up breaking this problem down into "chunks". I placed a formula in one cell that would locate how many positions over the last decimal point was. I then plugged that into another formula (in another cell) to grab the last octet (which also grabbed the decimal point as well). On the next cell, I stripped the decimal point and added one to the last octet, then on the final cell I used the CONCATENATE command to put it all together. I just found this way easier to understand.

I appreciate you helping out regardless. There are many ways to do one thing.

Andy