Hi Johnny.........

You can use Data Text to columns to separate the elements of your data
into individual columns, then you can do whatever math you wish to
them........and put them back together later if you wish with the
CONCATENATE function..........

hth
Vaya con Dios,
Chuck, CABGx3


"Johnny Z" <Johnny wrote in message
...
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