"Untitled Post" - Views: 49 · Hits: 49 - Type: Unlisted

B1
=SUBSTITUTE(A1,MID(A1,MIN(IF(IF(ISNUMBER(MID(A1,ROW(INDIRECT("1:99")),1)*1),MID(A1,ROW(INDIRECT("1:99")),1),"")<>"",ROW(INDIRECT("1:99")),"")),MAX(IF(IF(ISNUMBER(MID(A1,ROW(INDIRECT("1:99")),1)*1),MID(A1,ROW(INDIRECT("1:99")),1),"")<>"",ROW(INDIRECT("1:99")),""))-MIN(IF(IF(ISNUMBER(MID(A1,ROW(INDIRECT("1:99")),1)*1),MID(A1,ROW(INDIRECT("1:99")),1),"")<>"",ROW(INDIRECT("1:99")),""))+1),"")

C1
=MID(A1,MIN(IF(IF(ISNUMBER(MID(A1,ROW(INDIRECT("1:99")),1)*1),MID(A1,ROW(INDIRECT("1:99")),1),"")<>"",ROW(INDIRECT("1:99")),"")),MAX(IF(IF(ISNUMBER(MID(A1,ROW(INDIRECT("1:99")),1)*1),MID(A1,ROW(INDIRECT("1:99")),1),"")<>"",ROW(INDIRECT("1:99")),""))-MIN(IF(IF(ISNUMBER(MID(A1,ROW(INDIRECT("1:99")),1)*1),MID(A1,ROW(INDIRECT("1:99")),1),"")<>"",ROW(INDIRECT("1:99")),""))+1)