View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Colin Hayes Colin Hayes is offline
external usenet poster
 
Posts: 465
Default 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