How do I find the first occurrence of a number in a string? I have a list of
postcodes that will obviously have different digits.
I want to go from using many FIND functions e.g.,
=FIND(0,A1), then =FIND(1,A2) etc...
to
=FIND(0-9,A1)
what text would I need to put in to replace the "0-9"?
Thanks
Bookmarks