mathsbeauty
Board Regular
- Joined
- Apr 23, 2011
- Messages
- 89
There are numbers (1 to 4 digit numbers < 1000) followed by the word "Page" in a string. I want to replace the numbers appearing immediately after the word "Page" by "xyz". So the resulting string should be as "abcd Page xyz dfdfsda Page xyz fsadfds Page xyz" when the original string is "abcd Page 32 dfdfsda Page 1 fsadfds Page 4567". It would be nice if we can construct a function in Excel VBA for the same. If replacement is not possible, then removing numbers would also be okay.