Separate Numeric and Text data

"Aladin Akyurek" wrote...
{=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)+MI D(A1,1,seq)),0)-1)

--
To top-post is human, to bottom-post and snip is sublime.