{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","TEXTJOIN Function ","SEQUENCE Function ","LET Function","TRIM Function","VBA"],"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":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"Alphanumeric String ","Only Text Characters"]
[null,"A Thou4567sand Sp345lendid Sun23"]
[null,"T57he Kite000 Runn2848er"]
[null,"Th302e Rag6748ing B4u6l4l"]
[null,"A9p8oc5a89ly09ps4e N32o6w"]
[null,"N22ew 45Ye65a4rs E4ve"]
[null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies"]
[null,"D346i33e45 H64a56r239d"]

{"sheet":"TEXTJOIN Function ","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of TEXTJOIN Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Alphanumeric String ","Only Text Characters",null,null,null,null,null,null,"Alphanumeric String ","Only Text Characters"]
[null,"A Thou4567sand Sp345lendid Sun23",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B5,ROW(INDIRECT(\n\"1:100\")),1)+0),MID(B5,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"A Thousand Splendid Sun"},null,null,null,null,null,null,"A Thou4567sand Sp345lendid Sun23"]
[null,"T57he Kite000 Runn2848er",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B6,ROW(INDIRECT(\"1:100\")),1)+0),MID(B6,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"The Kite Runner"},null,null,null,null,null,null,"T57he Kite000 Runn2848er"]
[null,"Th302e Rag6748ing B4u6l4l",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B7,ROW(INDIRECT(\"1:100\")),1)+0),MID(B7,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"The Raging Bull"},null,null,null,null,null,null,"Th302e Rag6748ing B4u6l4l"]
[null,"A9p8oc5a89ly09ps4e N32o6w",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B8,ROW(INDIRECT(\"1:100\")),1)+0),MID(B8,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"Apocalypse Now"},null,null,null,null,null,null,"A9p8oc5a89ly09ps4e N32o6w"]
[null,"N22ew 45Ye65a4rs E4ve",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B9,ROW(INDIRECT(\"1:100\")),1)+0),MID(B9,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"New Years Eve"},null,null,null,null,null,null,"N22ew 45Ye65a4rs E4ve"]
[null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B10,ROW(INDIRECT(\"1:100\")),1)+0),MID(B10,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"A Tale of Two Cities"},null,null,null,null,null,null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies"]
[null,"D346i33e45 H64a56r239d",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B11,ROW(INDIRECT(\"1:100\")),1)+0),MID(B11,ROW(INDIRECT(\"1:100\")),1),\"\"))","v":"Die Hard"},null,null,null,null,null,null,"D346i33e45 H64a56r239d"]

{"sheet":"SEQUENCE Function ","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Combination of TEXTJOIN & SEQUENCE Functions",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Alphanumeric String ","Only Text Characters",null,null,null,null,null,null,"Alphanumeric String ","Only Text Characters"]
[null,"A Thou4567sand Sp345lendid Sun23",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B5,_xlfn.SEQUENCE(LEN(B5)),1)+0),MID(B5,_xlfn.SEQUENCE(LEN(B5)),1),\"\"))","v":"A Thousand Splendid Sun"},null,null,null,null,null,null,"A Thou4567sand Sp345lendid Sun23"]
[null,"T57he Kite000 Runn2848er",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B6,_xlfn.SEQUENCE(LEN(B6)),1)+0),MID(B6,_xlfn.SEQUENCE(LEN(B6)),1),\"\"))","v":"The Kite Runner"},null,null,null,null,null,null,"T57he Kite000 Runn2848er"]
[null,"Th302e Rag6748ing B4u6l4l",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B7,_xlfn.SEQUENCE(LEN(B7)),1)+0),MID(B7,_xlfn.SEQUENCE(LEN(B7)),1),\"\"))","v":"The Raging Bull"},null,null,null,null,null,null,"Th302e Rag6748ing B4u6l4l"]
[null,"A9p8oc5a89ly09ps4e N32o6w",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B8,_xlfn.SEQUENCE(LEN(B8)),1)+0),MID(B8,_xlfn.SEQUENCE(LEN(B8)),1),\"\"))","v":"Apocalypse Now"},null,null,null,null,null,null,"A9p8oc5a89ly09ps4e N32o6w"]
[null,"N22ew 45Ye65a4rs E4ve",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B9,_xlfn.SEQUENCE(LEN(B9)),1)+0),MID(B9,_xlfn.SEQUENCE(LEN(B9)),1),\"\"))","v":"New Years Eve"},null,null,null,null,null,null,"N22ew 45Ye65a4rs E4ve"]
[null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B10,_xlfn.SEQUENCE(LEN(B10)),1)+0),MID(B10,_xlfn.SEQUENCE(LEN(B10)),1),\"\"))","v":"A Tale of Two Cities"},null,null,null,null,null,null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies"]
[null,"D346i33e45 H64a56r239d",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B11,_xlfn.SEQUENCE(LEN(B11)),1)+0),MID(B11,_xlfn.SEQUENCE(LEN(B11)),1),\"\"))","v":"Die Hard"},null,null,null,null,null,null,"D346i33e45 H64a56r239d"]

{"sheet":"LET Function","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of LET Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Alphanumeric String ","Only Text Characters",null,null,null,null,null,null,"Alphanumeric String ","Only Text Characters"]
[null,"A Thou4567sand Sp345lendid Sun23",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B5)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B5,_xlpm.ARRAY,1)+0),MID(B5,_xlpm.ARRAY,1),\"\")))","v":"A Thousand Splendid Sun"},null,null,null,null,null,null,"A Thou4567sand Sp345lendid Sun23"]
[null,"T57he Kite000 Runn2848er",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B6)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B6,_xlpm.ARRAY,1)+0),MID(B6,_xlpm.ARRAY,1),\"\")))","v":"The Kite Runner"},null,null,null,null,null,null,"T57he Kite000 Runn2848er"]
[null,"Th302e Rag6748ing B4u6l4l",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B7)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B7,_xlpm.ARRAY,1)+0),MID(B7,_xlpm.ARRAY,1),\"\")))","v":"The Raging Bull"},null,null,null,null,null,null,"Th302e Rag6748ing B4u6l4l"]
[null,"A9p8oc5a89ly09ps4e N32o6w",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B8)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B8,_xlpm.ARRAY,1)+0),MID(B8,_xlpm.ARRAY,1),\"\")))","v":"Apocalypse Now"},null,null,null,null,null,null,"A9p8oc5a89ly09ps4e N32o6w"]
[null,"N22ew 45Ye65a4rs E4ve",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B9)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B9,_xlpm.ARRAY,1)+0),MID(B9,_xlpm.ARRAY,1),\"\")))","v":"New Years Eve"},null,null,null,null,null,null,"N22ew 45Ye65a4rs E4ve"]
[null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B10)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B10,_xlpm.ARRAY,1)+0),MID(B10,_xlpm.ARRAY,1),\"\")))","v":"A Tale of Two Cities"},null,null,null,null,null,null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies"]
[null,"D346i33e45 H64a56r239d",{"$f":"_xlfn.LET(_xlpm.ARRAY,_xlfn.SEQUENCE(LEN(B11)),_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B11,_xlpm.ARRAY,1)+0),MID(B11,_xlpm.ARRAY,1),\"\")))","v":"Die Hard"},null,null,null,null,null,null,"D346i33e45 H64a56r239d"]

{"sheet":"TRIM Function","index":4,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of TRIM Function",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Alphanumeric String ","Only Text Characters",null,null,null,null,null,null,"Alphanumeric String ","Only Text Characters"]
[null,"A Thou4567sand   Sp345lendid Sun 23",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B5,ROW(INDIRECT(\"1:100\")),1)+0),MID(B5,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"A Thousand Splendid Sun"},null,null,null,null,null,null,"A Thou4567sand   Sp345lendid Sun 23"]
[null,"T57he Kit  e000 Runn2848er",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B6,ROW(INDIRECT(\"1:100\")),1)+0),MID(B6,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"The Kit e Runner"},null,null,null,null,null,null,"T57he Kit  e000 Runn2848er"]
[null,"Th302e     Rag6748ing 6       B4u6l4l",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B7,ROW(INDIRECT(\"1:100\")),1)+0),MID(B7,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"The Raging Bull"},null,null,null,null,null,null,"Th302e     Rag6748ing 6       B4u6l4l"]
[null,"A9p8oc5a89ly09ps4e 8       N32o6w",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B8,ROW(INDIRECT(\"1:100\")),1)+0),MID(B8,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"Apocalypse Now"},null,null,null,null,null,null,"A9p8oc5a89ly09ps4e 8       N32o6w"]
[null,"N22ew 47      5Ye65a4rs E4ve",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B9,ROW(INDIRECT(\"1:100\")),1)+0),MID(B9,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"New Years Eve"},null,null,null,null,null,null,"N22ew 47      5Ye65a4rs E4ve"]
[null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B10,ROW(INDIRECT(\"1:100\")),1)+0),MID(B10,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"A Tale of Two Cities"},null,null,null,null,null,null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies"]
[null,"D346i33e4     5 H64a56r239d88   96",{"$f":"TRIM(_xlfn.TEXTJOIN(\"\",TRUE,IF(ISERR(MID(B11,ROW(INDIRECT(\"1:100\")),1)+0),MID(B11,ROW(INDIRECT(\"1:100\")),1),\"\")))","v":"Die Hard"},null,null,null,null,null,null,"D346i33e4     5 H64a56r239d88   96"]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Use of VBA Code",null,null,null,null,null,null,null,"Practice Yourself"]
[]
[null,"Alphanumeric String ","Only Text Characters",null,null,null,null,null,null,"Alphanumeric String ","Only Text Characters"]
[null,"A Thou4567sand Sp345lendid Sun23","A Thousand Splendid Sun",null,null,null,null,null,null,"A Thou4567sand Sp345lendid Sun23"]
[null,"T57he Kite000 Runn2848er","The Kite Runner",null,null,null,null,null,null,"T57he Kite000 Runn2848er"]
[null,"Th302e Rag6748ing B4u6l4l","The Raging Bull",null,null,null,null,null,null,"Th302e Rag6748ing B4u6l4l"]
[null,"A9p8oc5a89ly09ps4e N32o6w","Apocalypse Now",null,null,null,null,null,null,"A9p8oc5a89ly09ps4e N32o6w"]
[null,"N22ew 45Ye65a4rs E4ve","New Years Eve",null,null,null,null,null,null,"N22ew 45Ye65a4rs E4ve"]
[null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies","A Tale of Two Cities",null,null,null,null,null,null,"A98 T2a34l5e of 45Tw8o 6Ci5t6ies"]
[null,"D346i33e45 H64a56r239d","Die Hard",null,null,null,null,null,null,"D346i33e45 H64a56r239d"]