IN Cell C14 I have an IP 10.7.182.1
I need that value +1 in the 3rd octet of c18
so my output would be 10.7.183.1
I also have an IP address that needs to be in cell6b that needs the first 3 octets copied but with a different value for the 4th octet in another cell.
Please help, if possible.
Bookmarks