VBA to find any nine-figure number

[Chayes]

HI All

I need to find and replace with a carriage return all occurrences of everything between a "£" sign and the next nine-figure number.

So for example all pattern like

£4.00 $0.42
477489528

Would be found and replaced with a carriage return.

The code would need to run through and replace all such instances. It always starts with the £ sign and ends with a nine-figure number.

Can someone help with some code for this? Grateful for any advice.



Best Wishes ,