{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["MIN, MID & RIGHT"," SUBSTITUTE, LEFT, MIN & FIND","Flash Fill","TEXTJOIN, INDIRECT & LEN","LOOKUP, MID, MIN & FIND","MID & SEARCH","VALUE,TRIM, MID & FIND","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":"MIN, MID & RIGHT","index":0,"n_rows":8,"n_cols":9,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,6,1,8]]}
[]
[null," Use of MIN, MID & RIGHT Functions",null,null,null,null,"Practice Yourself"]
[]
[null,"Text String","Position","Extracted Numbers",null,null,"Text String","Position","Extracted Numbers"]
[null,"Real Madrid 1902",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\"))","v":13},{"$f":"RIGHT(B5,LEN(B5)-C5+1)","v":"1902"},null,null,"Real Madrid 1902"]
[null,"Barcelona 1899",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\"))","v":11},{"$f":"RIGHT(B6,LEN(B6)-C6+1)","v":"1899"},null,null,"Barcelona 1899"]
[null,"Chelsea 1905",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\"))","v":9},"1905",null,null,"Chelsea 1905"]
[null,"Liverpool 1892",{"$f":"MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\"))","v":11},"1892",null,null,"Liverpool 1892"]

{"sheet":" SUBSTITUTE, LEFT, MIN & FIND","index":1,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of SUBSTITUTE, LEFT, MIN & FIND Functions",null,null,null,"Practice Yourself"]
[]
[null,"Text String","Extracted Numbers",null,null,"Text String","Extracted Numbers"]
[null,"Real Madrid1902",{"$f":"SUBSTITUTE(B5,LEFT(B5,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},B5),\"\"))-1),\"\")","v":"1902"},null,null,"Real Madrid1902"]
[null,"Barcelona1899",{"$f":"SUBSTITUTE(B6,LEFT(B6,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},B6),\"\"))-1),\"\")","v":"1899"},null,null,"Barcelona1899"]
[null,"Chelsea1905",{"$f":"SUBSTITUTE(B7,LEFT(B7,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},B7),\"\"))-1),\"\")","v":"1905"},null,null,"Chelsea1905"]
[null,"Liverpool1892",{"$f":"SUBSTITUTE(B8,LEFT(B8,MIN(IFERROR(FIND({0,1,2,3,4,5,6,7,8,9},B8),\"\"))-1),\"\")","v":"1892"},null,null,"Liverpool1892"]

{"sheet":"Flash Fill","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of 'Flash Fill' Feature",null,null,null,"Practice Yourself"]
[]
[null,"Text String","Extracted Numbers",null,null,"Text String","Extracted Numbers"]
[null,"Real Madrid 1902",1902,null,null,"Real Madrid 1902"]
[null,"Barcelona 1899",1899,null,null,"Barcelona 1899"]
[null,"Chelsea 1905",1905,null,null,"Chelsea 1905"]
[null,"Liverpool 1892",1892,null,null,"Liverpool 1892"]

{"sheet":"TEXTJOIN, INDIRECT & LEN","index":3,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of TEXTJOIN, INDIRECT & LEN Functions",null,null,null,"Practice Yourself"]
[]
[null,"Text String","Extracted Numbers",null,null,"Text String","Extracted Numbers"]
[null,"Real Madrid Year 1902 Club",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B5,ROW(INDIRECT(\"1:\"&LEN(B5))),1)*1,\"\"))","v":"1902"},null,null,"Real Madrid Year 1902 Club"]
[null,"Barcelona Year 1899 Club",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B6,ROW(INDIRECT(\"1:\"&LEN(B6))),1)*1,\"\"))","v":"1899"},null,null,"Barcelona Year 1899 Club"]
[null,"Chelsea Year 1905 Club",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B7,ROW(INDIRECT(\"1:\"&LEN(B7))),1)*1,\"\"))","v":"1905"},null,null,"Chelsea Year 1905 Club"]
[null,"Liverpool Year 1892 Club",{"$f":"_xlfn.TEXTJOIN(\"\",TRUE,IFERROR(MID(B8,ROW(INDIRECT(\"1:\"&LEN(B8))),1)*1,\"\"))","v":"1892"},null,null,"Liverpool Year 1892 Club"]

{"sheet":"LOOKUP, MID, MIN & FIND","index":4,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of LOOKUP, MID, MIN & FIND Functions",null,null,null,"Practice Yourself"]
[]
[null,"Text String","Extracted Numbers",null,null,"Text String","Extracted Numbers"]
[null,"Real Madrid Year 1902 Club",{"$f":"LOOKUP(10^6,1*MID(B5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B5&\"0123456789\",FIND(\"Year\",\" \"&B5&\" \"))),{2,3,4,5,6}))","v":1902},null,null,"Real Madrid Year 1902 Club"]
[null,"Barcelona Year 1899 Club",{"$f":"LOOKUP(10^6,1*MID(B6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B6&\"0123456789\",FIND(\"Year\",\" \"&B6&\" \"))),{2,3,4,5,6}))","v":1899},null,null,"Barcelona Year 1899 Club"]
[null,"Chelsea Year 1905 Club",{"$f":"LOOKUP(10^6,1*MID(B7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B7&\"0123456789\",FIND(\"Year\",\" \"&B7&\" \"))),{2,3,4,5,6}))","v":1905},null,null,"Chelsea Year 1905 Club"]
[null,"Liverpool Year 1892 Club",{"$f":"LOOKUP(10^6,1*MID(B8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},B8&\"0123456789\",FIND(\"Year\",\" \"&B8&\" \"))),{2,3,4,5,6}))","v":1892},null,null,"Liverpool Year 1892 Club"]

{"sheet":"MID & SEARCH","index":5,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of MID & SEARCH Functions",null,null,null,"Practice Yourself"]
[]
[null,"Text String","Extracted Numbers",null,null,"Text String","Extracted Numbers"]
[null,"Real Madrid Year 1902 Club",{"$f":"MID(B5,SEARCH(\"Year \",B5)+4,SEARCH(\" Club\",B5)-SEARCH(\"Year \",B5)-4)","v":" 1902"},null,null,"Real Madrid Year 1902 Club"]
[null,"Barcelona Year 1899 Club",{"$f":"MID(B6,SEARCH(\"Year \",B6)+4,SEARCH(\" Club\",B6)-SEARCH(\"Year \",B6)-4)","v":" 1899"},null,null,"Barcelona Year 1899 Club"]
[null,"Chelsea Year 1905 Club"," 1905",null,null,"Chelsea Year 1905 Club"]
[null,"Liverpool Year 1892 Club"," 1892",null,null,"Liverpool Year 1892 Club"]

{"sheet":"VALUE,TRIM, MID & FIND","index":6,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Use of VALUE,TRIM, MID & FIND Functions",null,null,null,"Practice Yourself"]
[]
[null,"Text String","Extracted Numbers",null,null,"Text String","Extracted Numbers"]
[null,"Real Madrid Year 1902 Club",{"$f":"VALUE(TRIM(MID(B5,18,FIND(\"Club\",B5)-19)))","v":1902},null,null,"Real Madrid Year 1902 Club"]
[null,"Barcelona Year 1899 Club",{"$f":"VALUE(TRIM(MID(B6,16,FIND(\"Club\",B6)-17)))","v":1899},null,null,"Barcelona Year 1899 Club"]

{"sheet":"VBA","index":7,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Use of VBA Code"]
[]
[null,"Text String","Extracted Numbers"]
[null,"Real Madrid Year 1902 Club"]
[null,"Barcelona Year 1899 Club"]
[null,"Chelsea Year 1905 Club"]
[null,"Liverpool Year 1892 Club"]