{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["main","from Left","from Right","any pos","Nesting","five digits","Using Flash Fill","VBA"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"main","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Extracting Numbers from Excel Cell"]
[]
[null,"Codes","Numbers"]
[null,"34DTXRF"]
[null,"92 DTXRF"]
[null,"14-PNTGHY"]
[null,"00LOPHY"]
[null,"062BNFGTR"]
[null,"121LOKHYGF"]
[null,"OHJUIGT"]
[null,"54 MJNBSG"]

{"sheet":"from Left","index":1,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5],[1,6,1,7]]}
[]
[null,"Extracting Numbers from the Left",null,null,null,null,"Input Text with Numbers in Codes Column"]
[]
[null,"Codes","Numbers",null,null,null,"Codes","Numbers"]
[null,"34DTXRF",{"$f":"LEFT(B5,SUM(LEN(B5)-LEN(SUBSTITUTE(B5,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"34"},null,null,null,null,{"$f":"LEFT(G5,SUM(LEN(G5)-LEN(SUBSTITUTE(G5,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"92 DTXRF",{"$f":"LEFT(B6,SUM(LEN(B6)-LEN(SUBSTITUTE(B6,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"92"},null,null,null,null,{"$f":"LEFT(G6,SUM(LEN(G6)-LEN(SUBSTITUTE(G6,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"14-PNTGHY",{"$f":"LEFT(B7,SUM(LEN(B7)-LEN(SUBSTITUTE(B7,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"14"},null,null,null,null,{"$f":"LEFT(G7,SUM(LEN(G7)-LEN(SUBSTITUTE(G7,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"00LOPHY",{"$f":"LEFT(B8,SUM(LEN(B8)-LEN(SUBSTITUTE(B8,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"00"},null,null,null,null,{"$f":"LEFT(G8,SUM(LEN(G8)-LEN(SUBSTITUTE(G8,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"062BNFGTR",{"$f":"LEFT(B9,SUM(LEN(B9)-LEN(SUBSTITUTE(B9,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"062"},null,null,null,null,{"$f":"LEFT(G9,SUM(LEN(G9)-LEN(SUBSTITUTE(G9,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"121LOKHYGF",{"$f":"LEFT(B10,SUM(LEN(B10)-LEN(SUBSTITUTE(B10,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"121"},null,null,null,null,{"$f":"LEFT(G10,SUM(LEN(G10)-LEN(SUBSTITUTE(G10,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"OHJUIGT",{"$f":"LEFT(B11,SUM(LEN(B11)-LEN(SUBSTITUTE(B11,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""},null,null,null,null,{"$f":"LEFT(G11,SUM(LEN(G11)-LEN(SUBSTITUTE(G11,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]
[null,"54 MJNBSG",{"$f":"LEFT(B12,SUM(LEN(B12)-LEN(SUBSTITUTE(B12,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":"54"},null,null,null,null,{"$f":"LEFT(G12,SUM(LEN(G12)-LEN(SUBSTITUTE(G12,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]

{"sheet":"from Right","index":2,"n_rows":16,"n_cols":26,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Extracting Numbers from the Right",null,null,"Input Text with Numbers in Codes Column"]
[]
[null,"Codes","Numbers",null,"Codes","Numbers"]
[null,"DTXRF34",{"$f":"RIGHT(B5,LEN(B5) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B5&\"0123456789\")) +1)","v":"34"},null,null,{"$f":"RIGHT(E5,LEN(E5) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E5&\"0123456789\")) +1)","v":""}]
[null,"DTXRF 27",{"$f":"RIGHT(B6,LEN(B6) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B6&\"0123456789\")) +1)","v":"27"},null,null,{"$f":"RIGHT(E6,LEN(E6) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E6&\"0123456789\")) +1)","v":""}]
[null,"PNTGHY7",{"$f":"RIGHT(B7,LEN(B7) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B7&\"0123456789\")) +1)","v":"7"},null,null,{"$f":"RIGHT(E7,LEN(E7) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E7&\"0123456789\")) +1)","v":""}]
[null,"LOPHY00",{"$f":"RIGHT(B8,LEN(B8) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B8&\"0123456789\")) +1)","v":"00"},null,null,{"$f":"RIGHT(E8,LEN(E8) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E8&\"0123456789\")) +1)","v":""}]
[null,"BNFGTR-2",{"$f":"RIGHT(B9,LEN(B9) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B9&\"0123456789\")) +1)","v":"2"},null,null,{"$f":"RIGHT(E9,LEN(E9) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E9&\"0123456789\")) +1)","v":""}]
[null,"LOKHYGF99",{"$f":"RIGHT(B10,LEN(B10) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B10&\"0123456789\")) +1)","v":"99"},null,null,{"$f":"RIGHT(E10,LEN(E10) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E10&\"0123456789\")) +1)","v":""}]
[null,"OHJUIGT",{"$f":"RIGHT(B11,LEN(B11) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B11&\"0123456789\")) +1)","v":""},null,null,{"$f":"RIGHT(E11,LEN(E11) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E11&\"0123456789\")) +1)","v":""}]
[null,"MJNBSG131",{"$f":"RIGHT(B12,LEN(B12) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, B12&\"0123456789\")) +1)","v":"131"},null,null,{"$f":"RIGHT(E12,LEN(E12) - MIN(SEARCH({0,1,2,3,4,5,6,7,8,9}, E12&\"0123456789\")) +1)","v":""}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"LEFT(A2,SUM(LEN(A2)-LEN(SUBSTITUTE(A2,{\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"},\"\"))))","v":""}]

{"sheet":"any pos","index":3,"n_rows":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Extracting Numbers from Any Position in a Cell",null,null,null,"Input Text with Numbers in Codes Column"]
[]
[null,"Codes","Numbers",null,null,"Codes","Numbers"]
[null,"19 DDX2MN",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1),\"\"))","v":"192"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F5,ROW(INDIRECT(\"1:\"&LEN(F5))),1)*1),\"\"))","v":""}]
[null,"FXT23-DI12",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1),\"\"))","v":"2312"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F6,ROW(INDIRECT(\"1:\"&LEN(F6))),1)*1),\"\"))","v":""}]
[null,"KTXRY-PL34",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1),\"\"))","v":"34"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F7,ROW(INDIRECT(\"1:\"&LEN(F7))),1)*1),\"\"))","v":""}]
[null,"6-1ATRQL",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1),\"\"))","v":"61"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F8,ROW(INDIRECT(\"1:\"&LEN(F8))),1)*1),\"\"))","v":""}]
[null,"LHTYV-HG",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1)*1),\"\"))","v":""},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F9,ROW(INDIRECT(\"1:\"&LEN(F9))),1)*1),\"\"))","v":""}]
[null,"48PQTG1L",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1)*1),\"\"))","v":"481"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F10,ROW(INDIRECT(\"1:\"&LEN(F10))),1)*1),\"\"))","v":""}]
[null,"GT-1-KL90-AY",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1)*1),\"\"))","v":"190"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F11,ROW(INDIRECT(\"1:\"&LEN(F11))),1)*1),\"\"))","v":""}]
[null,"LOP6T23B1 N4",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(B12,ROW(INDIRECT(\"1:\"&LEN(B12))),1)*1),\"\"))","v":"62314"},null,null,null,{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR((MID(F12,ROW(INDIRECT(\"1:\"&LEN(F12))),1)*1),\"\"))","v":""}]

{"sheet":"Nesting","index":4,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Nesting Multiple Functions to Bring Out Only Numbers",null,null,null,null,"Input Text with Numbers in Codes Column"]
[]
[null,"Codes","Numbers",null,null,null,"Codes","Numbers"]
[null,"19 DDX2MN",{"$f":"IF(SUM(LEN(B5)-LEN(SUBSTITUTE(B5, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B5, LARGE(INDEX(ISNUMBER(--MID(B5,ROW(INDIRECT(\"$1:$\"&LEN(B5))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B5))),0), ROW(INDIRECT(\"$1:$\"&LEN(B5))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B5)))/10),\"\")","v":192},null,null,null,null,{"$f":"IF(SUM(LEN(G5)-LEN(SUBSTITUTE(G5, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G5, LARGE(INDEX(ISNUMBER(--MID(G5,ROW(INDIRECT(\"$1:$\"&LEN(G5))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G5))),0), ROW(INDIRECT(\"$1:$\"&LEN(G5))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G5)))/10),\"\")","v":""}]
[null,"FXT23-DI12",{"$f":"IF(SUM(LEN(B6)-LEN(SUBSTITUTE(B6, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B6, LARGE(INDEX(ISNUMBER(--MID(B6,ROW(INDIRECT(\"$1:$\"&LEN(B6))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B6))),0), ROW(INDIRECT(\"$1:$\"&LEN(B6))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B6)))/10),\"\")","v":2312},null,null,null,null,{"$f":"IF(SUM(LEN(G6)-LEN(SUBSTITUTE(G6, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G6, LARGE(INDEX(ISNUMBER(--MID(G6,ROW(INDIRECT(\"$1:$\"&LEN(G6))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G6))),0), ROW(INDIRECT(\"$1:$\"&LEN(G6))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G6)))/10),\"\")","v":""}]
[null,"KTXRY-PL34",{"$f":"IF(SUM(LEN(B7)-LEN(SUBSTITUTE(B7, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B7, LARGE(INDEX(ISNUMBER(--MID(B7,ROW(INDIRECT(\"$1:$\"&LEN(B7))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B7))),0), ROW(INDIRECT(\"$1:$\"&LEN(B7))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B7)))/10),\"\")","v":34},null,null,null,null,{"$f":"IF(SUM(LEN(G7)-LEN(SUBSTITUTE(G7, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G7, LARGE(INDEX(ISNUMBER(--MID(G7,ROW(INDIRECT(\"$1:$\"&LEN(G7))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G7))),0), ROW(INDIRECT(\"$1:$\"&LEN(G7))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G7)))/10),\"\")","v":""}]
[null,"6-1ATRQL",{"$f":"IF(SUM(LEN(B8)-LEN(SUBSTITUTE(B8, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B8, LARGE(INDEX(ISNUMBER(--MID(B8,ROW(INDIRECT(\"$1:$\"&LEN(B8))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B8))),0), ROW(INDIRECT(\"$1:$\"&LEN(B8))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B8)))/10),\"\")","v":61},null,null,null,null,{"$f":"IF(SUM(LEN(G8)-LEN(SUBSTITUTE(G8, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G8, LARGE(INDEX(ISNUMBER(--MID(G8,ROW(INDIRECT(\"$1:$\"&LEN(G8))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G8))),0), ROW(INDIRECT(\"$1:$\"&LEN(G8))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G8)))/10),\"\")","v":""}]
[null,"LHTYV-HG",{"$f":"IF(SUM(LEN(B9)-LEN(SUBSTITUTE(B9, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B9, LARGE(INDEX(ISNUMBER(--MID(B9,ROW(INDIRECT(\"$1:$\"&LEN(B9))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B9))),0), ROW(INDIRECT(\"$1:$\"&LEN(B9))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B9)))/10),\"\")","v":""},null,null,null,null,{"$f":"IF(SUM(LEN(G9)-LEN(SUBSTITUTE(G9, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G9, LARGE(INDEX(ISNUMBER(--MID(G9,ROW(INDIRECT(\"$1:$\"&LEN(G9))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G9))),0), ROW(INDIRECT(\"$1:$\"&LEN(G9))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G9)))/10),\"\")","v":""}]
[null,"48PQTG1L",{"$f":"IF(SUM(LEN(B10)-LEN(SUBSTITUTE(B10, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B10, LARGE(INDEX(ISNUMBER(--MID(B10,ROW(INDIRECT(\"$1:$\"&LEN(B10))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B10))),0), ROW(INDIRECT(\"$1:$\"&LEN(B10))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B10)))/10),\"\")","v":481},null,null,null,null,{"$f":"IF(SUM(LEN(G10)-LEN(SUBSTITUTE(G10, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G10, LARGE(INDEX(ISNUMBER(--MID(G10,ROW(INDIRECT(\"$1:$\"&LEN(G10))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G10))),0), ROW(INDIRECT(\"$1:$\"&LEN(G10))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G10)))/10),\"\")","v":""}]
[null,"GT-1-KL90-AY",{"$f":"IF(SUM(LEN(B11)-LEN(SUBSTITUTE(B11, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B11, LARGE(INDEX(ISNUMBER(--MID(B11,ROW(INDIRECT(\"$1:$\"&LEN(B11))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B11))),0), ROW(INDIRECT(\"$1:$\"&LEN(B11))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B11)))/10),\"\")","v":190},null,null,null,null,{"$f":"IF(SUM(LEN(G11)-LEN(SUBSTITUTE(G11, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G11, LARGE(INDEX(ISNUMBER(--MID(G11,ROW(INDIRECT(\"$1:$\"&LEN(G11))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G11))),0), ROW(INDIRECT(\"$1:$\"&LEN(G11))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G11)))/10),\"\")","v":""}]
[null,"LOP6T23B1 N4",{"$f":"IF(SUM(LEN(B12)-LEN(SUBSTITUTE(B12, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,SUMPRODUCT(MID(0&B12, LARGE(INDEX(ISNUMBER(--MID(B12,ROW(INDIRECT(\"$1:$\"&LEN(B12))),1))*ROW(INDIRECT(\"$1:$\"&LEN(B12))),0), ROW(INDIRECT(\"$1:$\"&LEN(B12))))+1,1) *10^ROW(INDIRECT(\"$1:$\"&LEN(B12)))/10),\"\")","v":62314},null,null,null,null,{"$f":"IF(SUM(LEN(G12)-LEN(SUBSTITUTE(G12, {\"0\",\"1\",\"2\",\"3\",\"4\",\"5\",\"6\",\"7\",\"8\",\"9\"}, \"\")))>0,\nSUMPRODUCT(MID(0&G12, LARGE(INDEX(ISNUMBER(--MID(G12,ROW(INDIRECT(\"$1:$\"&LEN(G12))),1))*\nROW(INDIRECT(\"$1:$\"&LEN(G12))),0), ROW(INDIRECT(\"$1:$\"&LEN(G12))))+1,1) *\n10^ROW(INDIRECT(\"$1:$\"&LEN(G12)))/10),\"\")","v":""}]

{"sheet":"five digits","index":5,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7],[1,11,1,12],[1,15,1,16]]}
[]
[null,"Extracting Five Digit Numbers from String",null,null,null,null,"Do Yourself by Using Flash Fill"]
[]
[null,"Codes","Numbers",null,null,null,"Codes","Numbers"]
[null,"19 DDX2MN33",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B5,_xlfn.SEQUENCE(LEN(B5)),1),\"\"))","v":"19233"},null,null,null,"19 DDX2MN"]
[null,"FXT2315-DI2",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B6,_xlfn.SEQUENCE(LEN(B6)),1),\"\"))","v":"23152"},null,null,null,"FXT23-DI12"]
[null,"KTXRY178-PL34",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B7,_xlfn.SEQUENCE(LEN(B7)),1),\"\"))","v":"17834"},null,null,null,"KTXRY-PL34"]
[null,"6-1523ATRQL",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B8,_xlfn.SEQUENCE(LEN(B8)),1),\"\"))","v":"61523"},null,null,null,"6-1ATRQL"]
[null,"LHTYV-HG",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B9,_xlfn.SEQUENCE(LEN(B9)),1),\"\"))","v":""},null,null,null,"LHTYV-HG"]
[null,"48PQTG551L",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B10,_xlfn.SEQUENCE(LEN(B10)),1),\"\"))","v":"48551"},null,null,null,"48PQTG1L"]
[null,"GT-100-KL90-AY",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B11,_xlfn.SEQUENCE(LEN(B11)),1),\"\"))","v":"10090"},null,null,null,"GT-1-KL90-AY"]
[null,"LOP6T23B1 N4",{"$f":"_xlfn.CONCAT(IFERROR(0+MID(B12,_xlfn.SEQUENCE(LEN(B12)),1),\"\"))","v":"62314"},null,null,null,"LOP6T23B1 N4"]

{"sheet":"Using Flash Fill","index":6,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12],[1,15,1,16],[1,6,1,7]]}
[]
[null,"Using Flash Fill to Extract Numbers",null,null,null,null,"Do Yourself by Using Flash Fill"]
[]
[null,"Codes","Numbers",null,null,null,"Codes","Numbers"]
[null,"19 DDX2MN",192,null,null,null,"19 DDX2MN"]
[null,"FXT23-DI12",2312,null,null,null,"FXT23-DI12"]
[null,"KTXRY-PL34",34,null,null,null,"KTXRY-PL34"]
[null,"6-1ATRQL",61,null,null,null,"6-1ATRQL"]
[null,"LHTYV-HG",null,null,null,null,"LHTYV-HG"]
[null,"48PQTG1L",481,null,null,null,"48PQTG1L"]
[null,"GT-1-KL90-AY",190,null,null,null,"GT-1-KL90-AY"]
[null,"LOP6T23B1 N4",62314,null,null,null,"LOP6T23B1 N4"]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying VBA"]
[]
[null,"Codes","Numbers"]
[null,"19 DDX2MN",192]
[null,"FXT23-DI12",2312]
[null,"KTXRY-PL34",34]
[null,"6-1ATRQL",61]
[null,"LHTYV-HG"]
[null,"48PQTG1L",481]
[null,"GT-1-KL90-AY",190]
[null,"LOP6T23B1 N4",62314]