Each of the 4 pieces of the IP address is a number between 0 and 256. What do
you mean when you say you want to add 9000 to the last 2 segments?


On Sun, 6 Feb 2005 18:19:01 -0800, "Johnny Z" <Johnny
wrote:

Here is my delima.
In one column I have a bunch of IP addresses like 192.168.x.x. I want to
take the x.x numbers and add 9000 to it and put the result in a different
column. I hope there is some way to do this in excel. I am sorry I am a new
to excel and spent hrs searching the forum but did not find an answer.
Thanks a million for your help