Ip address change

[SQLScholar]

hey áll,

I have 81 address ranges in excel looking like xxx.xxx.xxx.xxx - yyy.yyy.yyy.yyy and i want to change them into xxx.xxx.xxx.xxx/22 for instance.

Any way to do this, either in excel or a program somewhere?

Manually is taking for ever!

Thanks all,

D

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!

 

[ChrisHirst]

Hardly a TCP/IP problem.

you'll probably need to write a macro. try the MS office forum forum68



Chris.

Indifference will be the downfall of mankind, but who cares?

 

[SQLScholar]

Errr... it is because the people in the office forum (where i posted first) didnt understand how to do the conversion. So where would know... hang on there the IP people might have this problem every day and could help.

Sorry to be negative, but surely you would have thought that is where is started.

Sorted it now anyway ;-)

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!