I have text like:

```
#1 Supermarket 3454
Ubermarket 23478
Single_Token
Two Tokens
As many tokens as you like
```

And I'd like to remove the last number (when it appears) so I'm left with:

```
#1 Supermarket
Ubermarket
Single_Token
Two Tokens
As many tokens as you like
```

The data is added to regularly, so I would appreciate using an excel formula and not a mandrolic method using column splitting, or the like.

However I can't figure out how to use find to find all numbers, or substitute to only take number off the end.

edit: as people seem to neeed me to prove my accepted answer works, here is a screenshot:

it means duplicating the code in all the spreadsheetsWhy? you can place it into common module - it will be available on all sheets in this workbook. You can place it into personal macro storage - it will be available in all workbooks on your workstation. – Akina Jul 24 at 13:32