Find and replace consecutive numbers
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
|