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