• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

IP formula needed

Rui Pires

Member
Hello everybody;

I have a problem to solve:

31152.jpg

as shown on pic , i want a formula in C5.....Cn ,
I'd really like your help.

Thanks in advance
 
Hi ,

In C2 you can have :

=LEFT(A2,FIND("|",SUBSTITUTE(A2,".","|",3))-1) & "." & MID(A2,FIND("|",SUBSTITUTE(A2,".","|",3))+1,3)+1

Change this accordingly for D2 , and copy down.

There is no error checking , and if the last octet is 255 , this will return 256 !

Narayan
 
Back
Top