Separate at first numeric character

I have a lot of companies with their addresses in the same cell. I need to find a way to seperate the company name from the address.

Example:

Company Inc. 123 Street Ave. Ste. 500

I need to have "Company Inc." in one column and "123 Street Ave. Ste. 500" in the next column.

Is there a formula that I can use to seperate data at the first numerical character from the left?

I appreciate any help! Thank you : )

Try this formula in B1 to get everything up to the first number, assuming data in A1

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

then in C1 for the rest

=TRIM(SUBSTITUTE(A1,B1,"",1))

Thank you so much! This works great!