Need to extract text between numbers in a string
This gets close:
in A5:
=MID($A$1,1,MATCH(TRUE,INDEX(ISNUMBER(-MID($A$1,ROW(OFFSET($1:$1,1,,LEN($A$1))),1)),),0)-1)
in A6:
=MID($A$1,SUM(INDEX(LEN(A$5:A5),))+1,IFERROR(MATCH (TRUE,INDEX(ISNUMBER(-MID($A$1,ROW(OFFSET($1:$1,SUM(INDEX(LEN(A$5:A5),)) +2,,LEN($A$1))),1)),),0),999))
Copied downward through to A15. It leaves a blank cell before every 2 digit number, but correcting this could require a much longer formula.
Steve D.
|