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: