Separate Numeric and Text data

[Harlan Grove]

{=LEFT(A1,MAX(ISNUMBER(-MID(A1,1,Seq))*Seq))}

with A1 housing:

14 Martin Place

returns 14 Mar instead of 14 just like the fairwinds formula.

...

True. And if A1 contained 123E14THSTREET, any formula using number conversion
would extract 123E14. Also, this functionality would vary by locale. This
doesn't alter the fact that text treatment is more robust, but it does require
that the criteria be more refined.

=LEFT(A1,MATCH(FALSE,ISNUMBER(MID("0"&A1,seq,2)+MID(A1,1,seq)),0)-1)