One way, using a formula ..

Assuming the data is in A2 down

192.168.1.1
192.168.1.25
192.168.1.115
etc

Put in B2:
=95000+MID(A2,SEARCH(".",A2,SEARCH(".",A2,SEARCH(" .",A2)+1)+1)+1,99)
Copy B2 down

This'll return:

95001
95025
95115
etc

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

"Johnny Z" wrote:

I am sorry I should have been more clear. We are going through a MPLS/BGP
conversion and I need assign private BGP AS numbers to each of the nodes.

So my Plan was to take and address like 192.168.1.xxx and create an AS
number 95xxx. Let me give you 3 examples:

192.168.1.1 would get a AS number 95001

192.168.1.25 would get AS number 95025

192.168.1.115 would get AS number 95115

I hope this clarifies my question. Again thanks a lot for your help



"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