Hi all,

I've put together a macro to format an extract from a fuel report but at the end of it I need to remove numbers in front of drivers names.

Eg

1. John smith
10. Joe bloggs
123. Peter piper

Should end up as

John smith
Joe blogs
Peter piper

All without the number, full stop and the space before the name.

What's the best way to achieve this please.

Thanks as always