{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","TEXTJOIN","TEXTJOIN INDEX","Flash Fill","Power Query","VBA","Multiple Cells"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":"Dataset","index":0,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dataset: Employee Information"]
[]
[null,"ID, Name & ZIP Code"]
[null,"1582008James45871"]
[null,"6633103Jim75421"]
[null,"1743987Robert99154"]
[null,"4545081Maria23765"]
[null,"1339847David31752"]
[null,"5827801Liz24981"]
[null,"1943749Martinez31952"]
[null,"5081019Henry65197"]
[null,"9358780Mary76109"]
[null,"5029318John61441"]
[null,"5532792Charles15428"]

{"sheet":"TEXTJOIN","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Extract Multiple Numbers: Using TEXTJOIN Function"]
[]
[null,"ID, Name & ZIP Code","ID & ZIP Code","ID","ZIP Code"]
[null,"1582008James45871",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B5, ROW($A$1:INDEX($A$1:$A$1000, LEN(B5))), 1), \"#;-#;0;\"))","v":"158200845871"},{"$f":"LEFT(C5,7)","v":"1582008"},{"$f":"RIGHT(C5,5)","v":"45871"}]
[null,"6633103Jim75421",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B6, ROW($A$1:INDEX($A$1:$A$1000, LEN(B6))), 1), \"#;-#;0;\"))","v":"663310375421"},{"$f":"LEFT(C6,7)","v":"6633103"},{"$f":"RIGHT(C6,5)","v":"75421"}]
[null,"1743987Robert99154",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B7, ROW($A$1:INDEX($A$1:$A$1000, LEN(B7))), 1), \"#;-#;0;\"))","v":"174398799154"},"1743987","99154"]
[null,"4545081Maria23765",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B8, ROW($A$1:INDEX($A$1:$A$1000, LEN(B8))), 1), \"#;-#;0;\"))","v":"454508123765"},"4545081","23765"]
[null,"1339847David31752",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B9, ROW($A$1:INDEX($A$1:$A$1000, LEN(B9))), 1), \"#;-#;0;\"))","v":"133984731752"},"1339847","31752"]
[null,"5827801Liz24981",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B10, ROW($A$1:INDEX($A$1:$A$1000, LEN(B10))), 1), \"#;-#;0;\"))","v":"582780124981"},"5827801","24981"]
[null,"1943749Martinez31952",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B11, ROW($A$1:INDEX($A$1:$A$1000, LEN(B11))), 1), \"#;-#;0;\"))","v":"194374931952"},"1943749","31952"]
[null,"5081019Henry65197",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B12, ROW($A$1:INDEX($A$1:$A$1000, LEN(B12))), 1), \"#;-#;0;\"))","v":"508101965197"},"5081019","65197"]
[null,"9358780Mary76109",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B13, ROW($A$1:INDEX($A$1:$A$1000, LEN(B13))), 1), \"#;-#;0;\"))","v":"935878076109"},"9358780","76109"]
[null,"5029318John61441",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B14, ROW($A$1:INDEX($A$1:$A$1000, LEN(B14))), 1), \"#;-#;0;\"))","v":"502931861441"},"5029318","61441"]
[null,"5532792Charles15428",{"$f":"_xlfn.TEXTJOIN(, 1, TEXT(MID(B15, ROW($A$1:INDEX($A$1:$A$1000, LEN(B15))), 1), \"#;-#;0;\"))","v":"553279215428"},"5532792","15428"]

{"sheet":"TEXTJOIN INDEX","index":2,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Applying TEXTJOIN with INDEX Function"]
[]
[null,"ID, Name & ZIP Code","ID & ZIP Code"]
[null,"1582008James45871",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1),\"\"))","v":"158200845871"}]
[null,"6633103Jim75421",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1),\"\"))","v":"663310375421"}]
[null,"1743987Robert99154",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1),\"\"))","v":"174398799154"}]
[null,"4545081Maria23765",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1),\"\"))","v":"454508123765"}]
[null,"1339847David31752",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B9,ROW(INDIRECT(\"1:\"&LEN(B9))),1),\"\"))","v":"133984731752"}]
[null,"5827801Liz24981",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B10,ROW(INDIRECT(\"1:\"&LEN(B10))),1),\"\"))","v":"582780124981"}]
[null,"1943749Martinez31952",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B11,ROW(INDIRECT(\"1:\"&LEN(B11))),1),\"\"))","v":"194374931952"}]
[null,"5081019Henry65197",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B12,ROW(INDIRECT(\"1:\"&LEN(B12))),1),\"\"))","v":"508101965197"}]
[null,"9358780Mary76109",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B13,ROW(INDIRECT(\"1:\"&LEN(B13))),1),\"\"))","v":"935878076109"}]
[null,"5029318John61441",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B14,ROW(INDIRECT(\"1:\"&LEN(B14))),1),\"\"))","v":"502931861441"}]
[null,"5532792Charles15428",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(--MID(B15,ROW(INDIRECT(\"1:\"&LEN(B15))),1),\"\"))","v":"553279215428"}]

{"sheet":"Flash Fill","index":3,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Multiple Numbers: Using Flash Fill Feature"]
[]
[null,"ID, Name & ZIP Code","ID & ZIP Code"]
[null,"1582008James45871",158200845871]
[null,"6633103Jim75421",663310375421]
[null,"1743987Robert99154",174398799154]
[null,"4545081Maria23765",454508123765]
[null,"1339847David31752",133984731752]
[null,"5827801Liz24981",582780124981]
[null,"1943749Martinez31952",194374931952]
[null,"5081019Henry65197",508101965197]
[null,"9358780Mary76109",935878076109]
[null,"5029318John61441",502931861441]
[null,"5532792Charles15428",553279215428]

{"sheet":"Power Query","index":4,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employing Power Query"]
[]
[null,"ID, Name & ZIP Code","ID & ZIP Code"]
[null,"1582008James45871","158200845871"]
[null,"6633103Jim75421","663310375421"]
[null,"1743987Robert99154","174398799154"]
[null,"4545081Maria23765","454508123765"]
[null,"1339847David31752","133984731752"]
[null,"5827801Liz24981","582780124981"]
[null,"1943749Martinez31952","194374931952"]
[null,"5081019Henry65197","508101965197"]
[null,"9358780Mary76109","935878076109"]
[null,"5029318John61441","502931861441"]
[null,"5532792Charles15428","553279215428"]

{"sheet":"VBA","index":5,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Extract Multiple Numbers: Using VBA Code"]
[]
[null,"ID, Name & ZIP Code","ID & ZIP Code"]
[null,"1582008James45871",{"$f":"ExtractMultipleNumbers(B5)","v":"158200845871"}]
[null,"6633103Jim75421",{"$f":"ExtractMultipleNumbers(B6)","v":"663310375421"}]
[null,"1743987Robert99154",{"$f":"ExtractMultipleNumbers(B7)","v":"174398799154"}]
[null,"4545081Maria23765",{"$f":"ExtractMultipleNumbers(B8)","v":"454508123765"}]
[null,"1339847David31752",{"$f":"ExtractMultipleNumbers(B9)","v":"133984731752"}]
[null,"5827801Liz24981",{"$f":"ExtractMultipleNumbers(B10)","v":"582780124981"}]
[null,"1943749Martinez31952",{"$f":"ExtractMultipleNumbers(B11)","v":"194374931952"}]
[null,"5081019Henry65197",{"$f":"ExtractMultipleNumbers(B12)","v":"508101965197"}]
[null,"9358780Mary76109",{"$f":"ExtractMultipleNumbers(B13)","v":"935878076109"}]
[null,"5029318John61441",{"$f":"ExtractMultipleNumbers(B14)","v":"502931861441"}]
[null,"5532792Charles15428",{"$f":"ExtractMultipleNumbers(B15)","v":"553279215428"}]

{"sheet":"Multiple Cells","index":6,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Extract Multiple Numbers in Multiple Cells"]
[]
[null,"ID, Name & ZIP Code","ID","ZIP Code"]
[null,"ID:1582008 ZIP: 45871",{"$f":"MID(B5,FIND(\"ID:\",B5)+LEN(\"ID:\"),FIND(\" \",B5,FIND(\"ID:\",B5)+LEN(\"ID:\"))-FIND(\"ID:\",B5)-LEN(\"ID:\"))","v":"1582008"},{"$f":"MID(B5,FIND(\"ZIP:\",B5)+LEN(\"ZIP:\"),9999)","v":" 45871"}]
[null,"ID:6633103 ZIP:75421",{"$f":"MID(B6,FIND(\"ID:\",B6)+LEN(\"ID:\"),FIND(\" \",B6,FIND(\"ID:\",B6)+LEN(\"ID:\"))-FIND(\"ID:\",B6)-LEN(\"ID:\"))","v":"6633103"},{"$f":"MID(B6,FIND(\"ZIP:\",B6)+LEN(\"ZIP:\"),9999)","v":"75421"}]
[null,"ID:1743987 ZIP:99154","1743987","99154"]
[null,"ID:4545081 ZIP:23765","4545081","23765"]
[null,"ID:1339847 ZIP:31752","1339847","31752"]
[null,"ID:5827801 ZIP:24981","5827801","24981"]
[null,"ID:1943749 ZIP:31952","1943749","31952"]
[null,"ID:5081019 ZIP:65197","5081019","65197"]
[null,"ID:9358780 ZIP:76109","9358780","76109"]
[null,"ID:5029318 ZIP:61441","5029318","61441"]
[null,"ID:5532792 ZIP:15428","5532792","15428"]