I assume that the A16 should be A1?

The problem with that is that any number ending with 9 will change 9 to 10,
hence 99.99.99.99 becomes 99.99.99.910 :-(
You could, of course trap for that, but it gets rather complicated depending
on whether or not you've got a 9 preceding the final 9.
--
David Biddulph

"muddan madhu" wrote in message
...
try this

=MID(A1,1,LEN(A16)-1)&RIGHT(A1,1)+1


On Oct 31, 5:52 pm, calvin wrote:
I have a ton (546) of ip address and i need to change just the last digit
so
there wont be a conflic when i try connecting to the network

ex 10.191.168.223 to 10.191.168.224
10.14.129.10 to 10.14.129.11
and the list goes on an on
help please