How to find any number in a string

[OpieWinston]

The goal is to extract just the names from the below addresses, and my idea was to use InStr() to find the first number which I could incorporate into Left(), but I don't know how to make Excel differentiate between letters and numbers.

Please Login or Register  to view this content.

Any ideas would be appreciated! Thanks!

[jindon]

Assuming data in col.A from A1 and out put in Col.B

Please Login or Register  to view this content.

[OpieWinston]

That'll work Jindon - thanks! Now to go to Google and learn what exactly is going on in that formula so I can incorporate into my VBA toolbox.

[jindon]

min(search({0,1,2,3,4,5,6,7,8,9},rc[-1]&""0123456789""))

Is finding the position of the first appearing number within a cell.
The reason for adding 0123456789 is to avoid error when the string is missing any one of number(s).

HTH

[OpieWinston]

That helps immensely! Thanks a ton!