Find where there is any number in a string

I am trying to parse addresses where the company name is in the same field.

I wanted to use find and then left and right, however i cannot use an or with find

For instance I have these addresses:

Loga Square East,27 Franklin Town Blvd Apt 1103
Londonbury Homes Inc 432 Jane St


for the first one i used =FIND("2",J1216) to give me the location of the 2 and then used len to see how long it is and then ran a left and a right function to parse.

There are two issues. Obviously the second addresses starts with a four so i need to include and OR and all the number 1,2,3,4,5,6,7,8,9.
Second issue is that i do not what it to find both the 2 and the 7 in the first address.

Any good formulas you can think of. We have thousands of addresses like this and it takes forever to do manually.

Is there a formula that can just locate the first number?

=MIN(SEARCH({0,1,2,3,4,5,6,7,8,9},A1&"0123456789"))

Should return the position of the first number in A1

Originally Posted by Tony Valko

=MIN(FIND({0,1,2,3,4,5,6,7,8,9},A1&1234567890))

Hadn't thought about the "0" placement. Good point!