{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Find & Replace","SUBSTITUTE Function","TEXTJOIN Functions","RIGHT & LEN Functions","Array Formula","Text to Columns","Flash Fill","VBA","Practice"],"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":"Find & Replace","index":0,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of Find & Replace"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",505]
[null,"KKV 506",506]
[null,"KKV 507",507]
[null,"KKV 508",508]
[null,"KKV 509",509]
[null,"KKV 510",510]
[null,"KKV 511",511]
[null,"KKV 512",512]

{"sheet":"SUBSTITUTE Function","index":1,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of SUBSTITUTE Function"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",{"$f":"SUBSTITUTE(B5,\"KKV\",\"\")","v":" 505"}]
[null,"KKV 506",{"$f":"SUBSTITUTE(B6,\"KKV\",\"\")","v":" 506"}]
[null,"KKV 507"," 507"]
[null,"KKV 508"," 508"]
[null,"KKV 509"," 509"]
[null,"KKV 510"," 510"]
[null,"KKV 511"," 511"]
[null,"KKV 512"," 512"]

{"sheet":"TEXTJOIN Functions","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of  TEXTJOIN, ROW, INDIRECT, LEN, & IFERROR Functions"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B5,\n_xlfn.SEQUENCE(LEN(B5)), 1) *1, \"\"))","v":"505"}]
[null,"KKV 506",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B6,\n_xlfn.SEQUENCE(LEN(B6)), 1) *1, \"\"))","v":"506"}]
[null,"KKV 507",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B7,\n_xlfn.SEQUENCE(LEN(B7)), 1) *1, \"\"))","v":"507"}]
[null,"KKV 508",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B8,\n_xlfn.SEQUENCE(LEN(B8)), 1) *1, \"\"))","v":"508"}]
[null,"KKV 509",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B9,\n_xlfn.SEQUENCE(LEN(B9)), 1) *1, \"\"))","v":"509"}]
[null,"KKV 510",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B10,\n_xlfn.SEQUENCE(LEN(B10)), 1) *1, \"\"))","v":"510"}]
[null,"KKV 511",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B11,\n_xlfn.SEQUENCE(LEN(B11)), 1) *1, \"\"))","v":"511"}]
[null,"KKV 512",{"$f":"_xlfn.TEXTJOIN(\"\", TRUE,IFERROR(MID(B12,\n_xlfn.SEQUENCE(LEN(B12)), 1) *1, \"\"))","v":"512"}]

{"sheet":"RIGHT & LEN Functions","index":3,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of RIGHT & LEN Functions"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",{"$f":"RIGHT(B5, LEN(B5)-3)","v":" 505"}]
[null,"KKV 506",{"$f":"RIGHT(B6, LEN(B6)-3)","v":" 506"}]
[null,"KKV 507"," 507"]
[null,"KKV 508"," 508"]
[null,"KKV 509"," 509"]
[null,"KKV 510"," 510"]
[null,"KKV 511"," 511"]
[null,"KKV 512",{"$f":"RIGHT(B12, LEN(B12)-3)","v":" 512"}]

{"sheet":"Array Formula","index":4,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of Array Formula"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",{"$f":"SUM(MID(0&B5,LARGE(INDEX(ISNUMBER(--MID(B5,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":505}]
[null,"KKV 506",{"$f":"SUM(MID(0&B6,LARGE(INDEX(ISNUMBER(--MID(B6,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":506}]
[null,"KKV 507",{"$f":"SUM(MID(0&B7,LARGE(INDEX(ISNUMBER(--MID(B7,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":507}]
[null,"KKV 508",{"$f":"SUM(MID(0&B8,LARGE(INDEX(ISNUMBER(--MID(B8,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":508}]
[null,"KKV 509",{"$f":"SUM(MID(0&B9,LARGE(INDEX(ISNUMBER(--MID(B9,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":509}]
[null,"KKV 510",{"$f":"SUM(MID(0&B10,LARGE(INDEX(ISNUMBER(--MID(B10,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":510}]
[null,"KKV 511",{"$f":"SUM(MID(0&B11,LARGE(INDEX(ISNUMBER(--MID(B11,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":511}]
[null,"KKV 512",{"$f":"SUM(MID(0&B12,LARGE(INDEX(ISNUMBER(--MID(B12,\nROW($1:$99),1))*ROW($1:$99),),ROW($1:$99))+1,\n1)*10^ROW($1:$99)/10)","v":512}]

{"sheet":"Text to Columns","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of Text to Columns"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV",505]
[null,"KKV",506]
[null,"KKV",507]
[null,"KKV",508]
[null,"KKV",509]
[null,"KKV",510]
[null,"KKV",511]
[null,"KKV",512]

{"sheet":"Flash Fill","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of Flash Fill"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",505]
[null,"KKV 506",506]
[null,"KKV 507",507]
[null,"KKV 508",508]
[null,"KKV 509",509]
[null,"KKV 510",510]
[null,"KKV 511",511]
[null,"KKV 512",512]

{"sheet":"VBA","index":7,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Usage of VBA"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505",{"$f":"DeleteTextsButNumbers(B5)","v":"505"}]
[null,"KKV 506",{"$f":"DeleteTextsButNumbers(B6)","v":"506"}]
[null,"KKV 507",{"$f":"DeleteTextsButNumbers(B7)","v":"507"}]
[null,"KKV 508",{"$f":"DeleteTextsButNumbers(B8)","v":"508"}]
[null,"KKV 509",{"$f":"DeleteTextsButNumbers(B9)","v":"509"}]
[null,"KKV 510",{"$f":"DeleteTextsButNumbers(B10)","v":"510"}]
[null,"KKV 511",{"$f":"DeleteTextsButNumbers(B11)","v":"511"}]
[null,"KKV 512",{"$f":"DeleteTextsButNumbers(B12)","v":"512"}]

{"sheet":"Practice","index":8,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Practice Here"]
[]
[null,"Old Tokens","New Tokens"]
[null,"KKV 505"]
[null,"KKV 506"]
[null,"KKV 507"]
[null,"KKV 508"]
[null,"KKV 509"]
[null,"KKV 510"]
[null,"KKV 511"]
[null,"KKV 512"]