{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","flash fill","LEFT","RIGHT","MID","FIND","SEARCH","end","start","any","Text to Columns","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":"Dataset","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"\"XYZ\" Company"]
[]
[null,"Product Code","Item","Sales"]
[null,"1801apple2022","Apple",4280]
[null,"1802orange2022","Orange",4804]
[null,"1803apricots2022","Apricots",2476]
[null,"1804banana2022","Banana",2212]
[null,"1805blackberries2022","Blackberries",3930]
[null,"1806blueberries2022","Blueberries",2227]
[null,"1807cherries2022","Cherries",2411]
[null,"1808clementine2022","Clementine",2560]

{"sheet":"flash fill","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Flash Fill Feature"]
[]
[null,"Product Code","ID No.","Item","Sales"]
[null,"1801apple2022",1801,"Apple",4280]
[null,"1802orange2022",1802,"Orange",4804]
[null,"1803apricots2022",1803,"Apricots",2476]
[null,"1804banana2022",1804,"Banana",2212]
[null,"1805blackberries2022",1805,"Blackberries",3930]
[null,"1806blueberries2022",1806,"Blueberries",2227]
[null,"1807cherries2022",1807,"Cherries",2411]
[null,"1808clementine2022",1808,"Clementine",2560]

{"sheet":"LEFT","index":2,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using LEFT Function"]
[]
[null,"Product Code","ID No.","Item","Sales"]
[null,"1801apple2022",{"$f":"VALUE(LEFT(B4,4))","v":1801},"Apple",4280]
[null,"1802orange2022",{"$f":"VALUE(LEFT(B5,4))","v":1802},"Orange",4804]
[null,"1803apricots2022",1803,"Apricots",2476]
[null,"1804banana2022",1804,"Banana",2212]
[null,"1805blackberries2022",1805,"Blackberries",3930]
[null,"1806blueberries2022",1806,"Blueberries",2227]
[null,"1807cherries2022",1807,"Cherries",2411]
[null,"1808clementine2022",1808,"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"RIGHT","index":3,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using RIGHT Function"]
[]
[null,"Product Code","Year","Item","Sales"]
[null,"1801apple2022",{"$f":"VALUE(RIGHT(B4,4))","v":2022},"Apple",4280]
[null,"1802orange2022",{"$f":"VALUE(RIGHT(B5,4))","v":2022},"Orange",4804]
[null,"1803apricots2022",2022,"Apricots",2476]
[null,"1804banana2022",2022,"Banana",2212]
[null,"1805blackberries2022",2022,"Blackberries",3930]
[null,"1806blueberries2022",2022,"Blueberries",2227]
[null,"1807cherries2022",2022,"Cherries",2411]
[null,"1808clementine2022",2022,"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"MID","index":4,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using MID Function"]
[]
[null,"Product Code","ID No.","Item","Sales"]
[null,"1801apple2022",{"$f":"VALUE(MID(B4,1,4))","v":1801},"Apple",4280]
[null,"1802orange2022",{"$f":"VALUE(MID(B5,1,4))","v":1802},"Orange",4804]
[null,"1803apricots2022",1803,"Apricots",2476]
[null,"1804banana2022",1804,"Banana",2212]
[null,"1805blackberries2022",1805,"Blackberries",3930]
[null,"1806blueberries2022",1806,"Blueberries",2227]
[null,"1807cherries2022",1807,"Cherries",2411]
[null,"1808clementine2022",1808,"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"FIND","index":5,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using FIND Function"]
[]
[null,"Product Code","Year","Item","Sales"]
[null,"apple18012022",{"$f":"VALUE(MID(B4,FIND(\"2022\",B4),4))","v":2022},"Apple",4280]
[null,"20221802orange",{"$f":"VALUE(MID(B5,FIND(\"2022\",B5),4))","v":2022},"Orange",4804]
[null,"1803apricots2022",2022,"Apricots",2476]
[null,"1804banana2022",2022,"Banana",2212]
[null,"blackberries20221805",2022,"Blackberries",3930]
[null,"2022blueberries1806",2022,"Blueberries",2227]
[null,"1807cherries2022",2022,"Cherries",2411]
[null,"2022clementine1808",2022,"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,"",null,""]

{"sheet":"SEARCH","index":6,"n_rows":20,"n_cols":12,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using SEARCH Function"]
[]
[null,"Product Code","Year","Item","Sales"]
[null,"apple18012022",{"$f":"VALUE(MID(B4,SEARCH(\"2022\",B4),4))","v":2022},"Apple",4280]
[null,"20221802orange",{"$f":"VALUE(MID(B5,SEARCH(\"2022\",B5),4))","v":2022},"Orange",4804]
[null,"1803apricots2022",2022,"Apricots",2476]
[null,"1804banana2022",2022,"Banana",2212]
[null,"blackberries20221805",2022,"Blackberries",3930]
[null,"2022blueberries1806",2022,"Blueberries",2227]
[null,"1807cherries2022",2022,"Cherries",2411]
[null,"2022clementine1808",2022,"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[]
[null,null,null,null,null,null,null,null,null,"",null,""]

{"sheet":"end","index":7,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Extracting Numbers from End Position"]
[]
[null,"Product Code","Year","Item","Sales"]
[null,"1801apple2022",{"$f":"IFERROR(VALUE(RIGHT(B4, LEN(B4) - MAX(IF(ISNUMBER(MID(B4, ROW(INDIRECT(\"1:\"&LEN(B4))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B4))), 0)))), \"\")","v":2022},"Apple",4280]
[null,"1802orange2022",{"$f":"IFERROR(VALUE(RIGHT(B5, LEN(B5) - MAX(IF(ISNUMBER(MID(B5, ROW(INDIRECT(\"1:\"&LEN(B5))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B5))), 0)))), \"\")","v":2022},"Orange",4804]
[null,"1803apricots2022",{"$f":"IFERROR(VALUE(RIGHT(B6, LEN(B6) - MAX(IF(ISNUMBER(MID(B6, ROW(INDIRECT(\"1:\"&LEN(B6))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B6))), 0)))), \"\")","v":2022},"Apricots",2476]
[null,"1804banana2022",{"$f":"IFERROR(VALUE(RIGHT(B7, LEN(B7) - MAX(IF(ISNUMBER(MID(B7, ROW(INDIRECT(\"1:\"&LEN(B7))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B7))), 0)))), \"\")","v":2022},"Banana",2212]
[null,"1805blackberries2022",{"$f":"IFERROR(VALUE(RIGHT(B8, LEN(B8) - MAX(IF(ISNUMBER(MID(B8, ROW(INDIRECT(\"1:\"&LEN(B8))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B8))), 0)))), \"\")","v":2022},"Blackberries",3930]
[null,"1806blueberries2022",{"$f":"IFERROR(VALUE(RIGHT(B9, LEN(B9) - MAX(IF(ISNUMBER(MID(B9, ROW(INDIRECT(\"1:\"&LEN(B9))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B9))), 0)))), \"\")","v":2022},"Blueberries",2227]
[null,"1807cherries2022",{"$f":"IFERROR(VALUE(RIGHT(B10, LEN(B10) - MAX(IF(ISNUMBER(MID(B10, ROW(INDIRECT(\"1:\"&LEN(B10))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B10))), 0)))), \"\")","v":2022},"Cherries",2411]
[null,"1808clementine2022",{"$f":"IFERROR(VALUE(RIGHT(B11, LEN(B11) - MAX(IF(ISNUMBER(MID(B11, ROW(INDIRECT(\"1:\"&LEN(B11))), 1)*1)=FALSE, ROW(INDIRECT(\"1:\"&LEN(B11))), 0)))), \"\")","v":2022},"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"start","index":8,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Extracting Numbers from Starting Position"]
[]
[null,"Product Code","ID No.","Item","Sales"]
[null,"1801apple2022",{"$f":"IFERROR(VALUE(LEFT(B4, MATCH(FALSE, ISNUMBER(MID(B4, ROW(INDIRECT(\"1:\"&LEN(B4)+1)), 1) *1), 0) -1)),\" \")","v":1801},"Apple",4280]
[null,"1802orange2022",{"$f":"IFERROR(VALUE(LEFT(B5, MATCH(FALSE, ISNUMBER(MID(B5, ROW(INDIRECT(\"1:\"&LEN(B5)+1)), 1) *1), 0) -1)),\" \")","v":1802},"Orange",4804]
[null,"1803apricots2022",{"$f":"IFERROR(VALUE(LEFT(B6, MATCH(FALSE, ISNUMBER(MID(B6, ROW(INDIRECT(\"1:\"&LEN(B6)+1)), 1) *1), 0) -1)),\" \")","v":1803},"Apricots",2476]
[null,"1804banana2022",{"$f":"IFERROR(VALUE(LEFT(B7, MATCH(FALSE, ISNUMBER(MID(B7, ROW(INDIRECT(\"1:\"&LEN(B7)+1)), 1) *1), 0) -1)),\" \")","v":1804},"Banana",2212]
[null,"1805blackberries2022",{"$f":"IFERROR(VALUE(LEFT(B8, MATCH(FALSE, ISNUMBER(MID(B8, ROW(INDIRECT(\"1:\"&LEN(B8)+1)), 1) *1), 0) -1)),\" \")","v":1805},"Blackberries",3930]
[null,"1806blueberries2022",{"$f":"IFERROR(VALUE(LEFT(B9, MATCH(FALSE, ISNUMBER(MID(B9, ROW(INDIRECT(\"1:\"&LEN(B9)+1)), 1) *1), 0) -1)),\" \")","v":1806},"Blueberries",2227]
[null,"1807cherries2022",{"$f":"IFERROR(VALUE(LEFT(B10, MATCH(FALSE, ISNUMBER(MID(B10, ROW(INDIRECT(\"1:\"&LEN(B10)+1)), 1) *1), 0) -1)),\" \")","v":1807},"Cherries",2411]
[null,"1808clementine2022",{"$f":"IFERROR(VALUE(LEFT(B11, MATCH(FALSE, ISNUMBER(MID(B11, ROW(INDIRECT(\"1:\"&LEN(B11)+1)), 1) *1), 0) -1)),\" \")","v":1808},"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"any","index":9,"n_rows":17,"n_cols":10,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Extracting Numbers from Any Position"]
[]
[null,"Product Code","ID No.&Year","Item","Sales"]
[null,"1801apple2022",{"$f":"SUMPRODUCT(MID(0&B4, LARGE(INDEX(ISNUMBER(--MID(B4, ROW(INDIRECT(\"1:\"&LEN(B4))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B4))), 0), ROW(INDIRECT(\"1:\"&LEN(B4))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B4)))/10)","v":18012022},"Apple",4280]
[null,"1802orange2022",{"$f":"SUMPRODUCT(MID(0&B5, LARGE(INDEX(ISNUMBER(--MID(B5, ROW(INDIRECT(\"1:\"&LEN(B5))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B5))), 0), ROW(INDIRECT(\"1:\"&LEN(B5))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B5)))/10)","v":18022022},"Orange",4804]
[null,"1803apricots2022",{"$f":"SUMPRODUCT(MID(0&B6, LARGE(INDEX(ISNUMBER(--MID(B6, ROW(INDIRECT(\"1:\"&LEN(B6))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B6))), 0), ROW(INDIRECT(\"1:\"&LEN(B6))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B6)))/10)","v":18032022},"Apricots",2476]
[null,"1804banana2022",{"$f":"SUMPRODUCT(MID(0&B7, LARGE(INDEX(ISNUMBER(--MID(B7, ROW(INDIRECT(\"1:\"&LEN(B7))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B7))), 0), ROW(INDIRECT(\"1:\"&LEN(B7))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B7)))/10)","v":18042022},"Banana",2212]
[null,"1805blackberries2022",{"$f":"SUMPRODUCT(MID(0&B8, LARGE(INDEX(ISNUMBER(--MID(B8, ROW(INDIRECT(\"1:\"&LEN(B8))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B8))), 0), ROW(INDIRECT(\"1:\"&LEN(B8))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B8)))/10)","v":18052022},"Blackberries",3930]
[null,"1806blueberries2022",{"$f":"SUMPRODUCT(MID(0&B9, LARGE(INDEX(ISNUMBER(--MID(B9, ROW(INDIRECT(\"1:\"&LEN(B9))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B9))), 0), ROW(INDIRECT(\"1:\"&LEN(B9))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B9)))/10)","v":18062022},"Blueberries",2227]
[null,"1807cherries2022",{"$f":"SUMPRODUCT(MID(0&B10, LARGE(INDEX(ISNUMBER(--MID(B10, ROW(INDIRECT(\"1:\"&LEN(B10))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B10))), 0), ROW(INDIRECT(\"1:\"&LEN(B10))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B10)))/10)","v":18072022},"Cherries",2411]
[null,"1808clementine2022",{"$f":"SUMPRODUCT(MID(0&B11, LARGE(INDEX(ISNUMBER(--MID(B11, ROW(INDIRECT(\"1:\"&LEN(B11))), 1)) * ROW(INDIRECT(\"1:\"&LEN(B11))), 0), ROW(INDIRECT(\"1:\"&LEN(B11))))+1, 1) * 10^ROW(INDIRECT(\"1:\"&LEN(B11)))/10)","v":18082022},"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]

{"sheet":"Text to Columns","index":10,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Using Text to Columns Option"]
[]
[null,"Product Code","ID No.","Item&Year"]
[null,"1801apple2022",1801,"apple2022"]
[null,"1802orange2022",1802,"orange2022"]
[null,"1803apricots2022",1803,"apricots2022"]
[null,"1804banana2022",1804,"banana2022"]
[null,"1805blackberries2022",1805,"blackberries2022"]
[null,"1806blueberries2022",1806,"blueberries2022"]
[null,"1807cherries2022",1807,"cherries2022"]
[null,"1808clementine2022",1808,"clementine2022"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,""]

{"sheet":"VBA","index":11,"n_rows":19,"n_cols":12,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VBA Code"]
[]
[null,"Product Code","Year","Item","Sales"]
[null,"1801apple2022",2022,"Apple",4280]
[null,"1802orange2022",2022,"Orange",4804]
[null,"1803apricots2022",2022,"Apricots",2476]
[null,"1804banana2022",2022,"Banana",2212]
[null,"1805blackberries2022",2022,"Blackberries",3930]
[null,"1806blueberries2022",2022,"Blueberries",2227]
[null,"1807cherries2022",2022,"Cherries",2411]
[null,"1808clementine2022",2022,"Clementine",2560]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,""]
[]
[null,null,null,null,null,null,null,null,null,null,null,""]

{"sheet":"Practice","index":12,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"Practice"]
[]
[null,"Product Code","Item","Sales"]
[null,"1801apple2022","Apple",4280]
[null,"1802orange2022","Orange",4804]
[null,"1803apricots2022","Apricots",2476]
[null,"1804banana2022","Banana",2212]
[null,"1805blackberries2022","Blackberries",3930]
[null,"1806blueberries2022","Blueberries",2227]
[null,"1807cherries2022","Cherries",2411]
[null,"1808clementine2022","Clementine",2560]