Separate Numeric and Text data

  • Thread starter Thread starter MG
  • Start date Start date
{=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.
Click to expand...
...

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)
 
Back
Top