I have a file in excel with the following formula referencing a cell with an IP address. The formula does not work when someone opens the file in google sheets and sometimes on other machines.

I have tried just replacing REPLACE with SUBSTITUTE and FIND with SEARCH. These have not produced the correct result.

The ref. cell is an IP address, the formula should increase the last octet by one number. 10.10.10.0 in ref cell becomes 10.10.10.1 in formula cell.

=REPLACE(J4,FIND(".",J4,FIND(".",J4,FIND(".",J4)+1)+1)+1,LEN(J4),MIN(255,MID(J4,FIND(".",J4,FIND(".",J4,FIND(".",J4)+1)+1)+1,LEN(J4)))+1)