{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["INDIRECT","SEQUENCE","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":"INDIRECT","index":0,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Using TEXTJOIN and INDIRECT",null,null,null,"Practice"]
[]
[null,"Data","Result ",null,null,"Data","Result "]
[null,"4006Jackson",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B5,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"4006"},null,null,"4006Jackson"]
[null,"I have 1000 Dollar",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B6,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"1000"},null,null,"I have 1000 Dollar"]
[null,"12Develop34",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B7,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"1234"},null,null,"12Develop34"]
[null,"Office365",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B8,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"365"},null,null,"Office365"]
[null,"Excel 2021, Excel 365 ",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B9,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"2021365"},null,null,"Excel 2021, Excel 365 "]

{"sheet":"SEQUENCE","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using TEXTJOIN and SEQUENCE",null,null,null,null,"Practice"]
[]
[null,"Data","Result ",null,null,null,"Data","Result "]
[null,"4006Jackson",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B5, _xlfn.SEQUENCE(LEN(B5)), 1) *1, \"\"))","v":"4006"},null,null,null,"4006Jackson"]
[null,"I have 1000 Dollar",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B6, _xlfn.SEQUENCE(LEN(B6)), 1) *1, \"\"))","v":"1000"},null,null,null,"I have 1000 Dollar"]
[null,"12Develop34",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B7, _xlfn.SEQUENCE(LEN(B7)), 1) *1, \"\"))","v":"1234"},null,null,null,"12Develop34"]
[null,"Office365",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B8, _xlfn.SEQUENCE(LEN(B8)), 1) *1, \"\"))","v":"365"},null,null,null,"Office365"]
[null,"Excel 2021, Excel 365 ",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B9, _xlfn.SEQUENCE(LEN(B9)), 1) *1, \"\"))","v":"2021365"},null,null,null,"Excel 2021, Excel 365 "]

{"sheet":"VBA","index":2,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using VBA Codes",null,null,null,null,"Practice"]
[]
[null,"Data","Result ",null,null,null,"Data","Result "]
[null,"4006Jackson",{"$f":"DeleteText(B5)","v":"4006"},null,null,null,"4006Jackson"]
[null,"I have 1000 Dollar",{"$f":"DeleteText(B6)","v":"1000"},null,null,null,"I have 1000 Dollar"]
[null,"12Develop34",{"$f":"DeleteText(B7)","v":"1234"},null,null,null,"12Develop34"]
[null,"Office365",{"$f":"DeleteText(B8)","v":"365"},null,null,null,"Office365"]
[null,"Excel 2021, Excel 365 ",{"$f":"DeleteText(B9)","v":"2021365"},null,null,null,"Excel 2021, Excel 365 "]