EDIT: Title shouldn't really say "Just letters", I'd like to find and replace everything that isn't a number.
Hello all,
I'm a frequent user of Python and this task would be fairly simple using the regex library however this is rising some challenges in excel. In Python I could just use a substitute function like so: re.sub(Pattern, Replacement, String) and substitute all letters with "".
However, in VBA there appears to be no regular expression library.
I have line items that looks like this: "account_23234232434 expenses", I would like to just substitute all non-digits for "" and have only "23234232434" remain. The numbers and words can be longer or shorter so using something like =left(right("account_23234232434 expenses", N), N) doesn't really work.
I know there is a replace function n VBA that I have used before but as far as I know it doesn't facilitate what I'm looking for.
Any solutions or suggestions?
Bookmarks