{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Sample Datasheet","TEXTJOIN and SEQUENCE","TEXTJOIN and INDIRECT","VBA Code"],"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":"Sample Datasheet","index":0,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2]]}
[]
[]
[null,"Removing Non Numeric Characters"]
[]
[null,"Text String","Final Result"]
[null,"BestPlayerLionel_Messi10"]
[null,"PR03vo1utionS0cc3R"]
[null,"de3dm0use"]
[null,"2002Brazil_Champion"]
[null,"Prioritydeadline - 15 December"]
[null,"100 dollars 25 cents"]
[null,"God of War Ragnarok 2022"]
[null,"Office365, Microsoft Office2016"]

{"sheet":"TEXTJOIN and SEQUENCE","index":1,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,6,2,7],[2,1,2,2]]}
[]
[]
[null,"Removing Non Numeric Characters",null,null,null,null,"For Practice"]
[]
[null,"Text String","Final Result",null,null,null,"Text String","Final Result"]
[null,"BestPlayerLionel_Messi10",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B6, _xlfn.SEQUENCE(LEN(B6)), 1) *1, \"\"))","v":"10"},null,null,null,"BestPlayerLionel_Messi10"]
[null,"PR03vo1utionS0cc3R",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B7, _xlfn.SEQUENCE(LEN(B7)), 1) *1, \"\"))","v":"03103"},null,null,null,"PR03vo1utionS0cc3R"]
[null,"de3dm0use",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B8, _xlfn.SEQUENCE(LEN(B8)), 1) *1, \"\"))","v":"30"},null,null,null,"de3dm0use"]
[null,"2002Brazil_Champion",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B9, _xlfn.SEQUENCE(LEN(B9)), 1) *1, \"\"))","v":"2002"},null,null,null,"2002Brazil_Champion"]
[null,"Prioritydeadline - 15 December",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B10, _xlfn.SEQUENCE(LEN(B10)), 1) *1, \"\"))","v":"15"},null,null,null,"Prioritydeadline - 15 December"]
[null,"100 dollars 25 cents",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B11, _xlfn.SEQUENCE(LEN(B11)), 1) *1, \"\"))","v":"10025"},null,null,null,"100 dollars 25 cents"]
[null,"God of War Ragnarok 2022",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B12, _xlfn.SEQUENCE(LEN(B12)), 1) *1, \"\"))","v":"2022"},null,null,null,"God of War Ragnarok 2022"]
[null,"Office365, Microsoft Office2016",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE, IFERROR(MID(B13, _xlfn.SEQUENCE(LEN(B13)), 1) *1, \"\"))","v":"3652016"},null,null,null,"Office365, Microsoft Office2016"]

{"sheet":"TEXTJOIN and INDIRECT","index":2,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Removing Non Numeric Characters",null,null,null,null,"For Practice"]
[]
[null,"Text String","Final Result",null,null,null,"Text String","Final Result"]
[null,"BestPlayerLionel_Messi10",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B6,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"10"},null,null,null,"BestPlayerLionel_Messi10"]
[null,"PR03vo1utionS0cc3R",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B7,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"03103"},null,null,null,"PR03vo1utionS0cc3R"]
[null,"de3dm0use",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B8,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"30"},null,null,null,"de3dm0use"]
[null,"2002Brazil_Champion",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B9,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"2002"},null,null,null,"2002Brazil_Champion"]
[null,"Prioritydeadline - 15 December",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B10,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"15"},null,null,null,"Prioritydeadline - 15 December"]
[null,"100 dollars 25 cents",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B11,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"10025"},null,null,null,"100 dollars 25 cents"]
[null,"God of War Ragnarok 2022",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B12,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"2022"},null,null,null,"God of War Ragnarok 2022"]
[null,"Office365, Microsoft Office2016",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B13,ROW(INDIRECT(\"1:100\")),1)+0,\"\"))","v":"3652016"},null,null,null,"Office365, Microsoft Office2016"]

{"sheet":"VBA Code","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7]]}
[]
[]
[null,"Removing Non Numeric Characters",null,null,null,null,"For Practice"]
[]
[null,"Text String","Final Result",null,null,null,"Text String","Final Result"]
[null,"BestPlayerLionel_Messi10",{"$f":"Remove_Non_Numeric_Character(B6)","v":"10"},null,null,null,"BestPlayerLionel_Messi10"]
[null,"PR03vo1utionS0cc3R",{"$f":"Remove_Non_Numeric_Character(B7)","v":"03103"},null,null,null,"PR03vo1utionS0cc3R"]
[null,"de3dm0use",{"$f":"Remove_Non_Numeric_Character(B8)","v":"30"},null,null,null,"de3dm0use"]
[null,"2002Brazil_Champion",{"$f":"Remove_Non_Numeric_Character(B9)","v":"2002"},null,null,null,"2002Brazil_Champion"]
[null,"Prioritydeadline - 15 December",{"$f":"Remove_Non_Numeric_Character(B10)","v":"15"},null,null,null,"Prioritydeadline - 15 December"]
[null,"100 dollars 25 cents",{"$f":"Remove_Non_Numeric_Character(B11)","v":"10025"},null,null,null,"100 dollars 25 cents"]
[null,"God of War Ragnarok 2022",{"$f":"Remove_Non_Numeric_Character(B12)","v":"2022"},null,null,null,"God of War Ragnarok 2022"]
[null,"Office365, Microsoft Office2016",{"$f":"Remove_Non_Numeric_Character(B13)","v":"3652016"},null,null,null,"Office365, Microsoft Office2016"]