One way, using a formula ..

Assuming the data is in A2 down

192.168.1.1
192.168.2.2
192.168.1.2
192.168.2.3
192.168.1.3
etc

Put in B2:

=LEFT(A2,SEARCH(".",A2)-1)&"."&MID(A2,SEARCH(".",A2)+1,SEARCH(".",A2,SEARC H(".",A2)+1)-SEARCH(".",A2)-1)&"."&MID(A2,SEARCH(".",A2,SEARCH(".",A2)+1)+1,SE ARCH(".",A2,SEARCH(".",A2,SEARCH(".",A2)+1)+1)-SEARCH(".",A2,SEARCH(".",A2)+1)-1)+9000&"."&MID(A2,SEARCH(".",A2,SEARCH(".",A2,SEA RCH(".",A2)+1)+1)+1,99)+9000

Copy B2 down

For the sample data, the above will return:

192.168.9001.9001
192.168.9002.9002
192.168.9001.9002
192.168.9002.9003
192.168.9001.9003
etc

Another way would be to use Data Text to Columns (delimited)
to split the data into 4 cols using the period: "." as the delimter

Then put 9000 in an empty cell, copy it,
select the 3rd and 4th cols and do a paste special add

And concatenate the 4 split cols back into a 5th col

--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

"Johnny Z" 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