Using a copy of your data.........try just sorting to get them all together,
then highlight them and do Exit Replace, and replace the period, with
nothing, leave the box empty, then ReplaceAll........

If it is necessary to return to the original sorting, the before doing the
above, use a helper column to put sequentioal numbers in and after the above
procedure, sort on the new helper column, then delete it if deisred.

Vaya con Dios,
Chuck, CABGx3




"Colin Hayes" wrote in message
...


Hi All

I have two columns J and K of text and numbers.

I need to find numbers down from 50 followed by a full stop

(50. , 49. , 48. , 47. Etc)

and replace with

<p50 , <p49 , and so on.

No full stop in the replace string.

I did manage to do this long-hand , replacing each one by one , only for
Excel to tell me that my procedure was now too long.

Can someone help with some neat VBA to do this? I'm grateful for any
help on this.




Best Wishes


Colin