| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace | Excel Discussion (Misc queries) | |||
| Find and replace numbers using a formula | Excel Worksheet Functions | |||
| How to cancel a find & replace command "midstream"? | Excel Worksheet Functions | |||
| Macro: Find and replace | Excel Discussion (Misc queries) | |||
| Find nth occurrence and replace with ":" | Excel Worksheet Functions | |||
Threaded Mode
