{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Dataset","Flash Fill","RIGHT,SEARCH","RIGHT,FIND","MID,FIND","SUBSTITUTE,LEFT","SUBSTITUTE,RIGHT","REPLACE","RIGHT,REPT","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":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,3]]}
[null,"\"XYZ\" Company"]
[]
[null,"Code","Region","Sales"]
[null,"XYZApple","North",4280]
[null,"XYZApricots","East",4804]
[null,"XYZBanana","South",2476]
[null,"XYZBlackberries","North",2212]
[null,"XYZBlueberries","West",3930]
[null,"XYZCherries","East",2227]
[null,"XYZClementine","South",2411]

{"sheet":"Flash Fill","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Flash Fill Feature"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple","Apple","North",4280]
[null,"XYZApricots","Apricots","East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"RIGHT,SEARCH","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using RIGHT,LEN,SEARCH Functions"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"RIGHT(B4,LEN(B4)-SEARCH(\"XYZ\",B4)-2)","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\"XYZ\",B5)-2)","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"RIGHT,FIND","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using RIGHT,LEN,FIND Functions"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"RIGHT(B4,LEN(B4)-FIND(\"XYZ\",B4)-2)","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"RIGHT(B5,LEN(B5)-FIND(\"XYZ\",B5)-2)","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"MID,FIND","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using MID,LEN,FIND Functions"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"MID(B4,FIND(\"XYZ\",B4)+3,LEN(B4)-FIND(\"XYZ\",B4)-2)","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"MID(B5,FIND(\"XYZ\",B5)+3,LEN(B5)-FIND(\"XYZ\",B5)-2)","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"SUBSTITUTE,LEFT","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using SUBSTITUTE,LEFT,FIND Functions"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"SUBSTITUTE(B4,LEFT(B4,FIND(\"XYZ\",B4)+2),\"\")","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"SUBSTITUTE(B5,LEFT(B5,FIND(\"XYZ\",B5)+2),\"\")","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"SUBSTITUTE,RIGHT","index":6,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using RIGHT,FIND,SUBSTITUTE Functions"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"RIGHT(B4,LEN(B4)-FIND(\"*\",SUBSTITUTE(B4,\"XYZ\",\"*\",1))-2)","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"RIGHT(B5,LEN(B5)-FIND(\"*\",SUBSTITUTE(B5,\"XYZ\",\"*\",1))-2)","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"REPLACE","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using REPLACE Function"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"REPLACE(B4,1,3,\"\")","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"REPLACE(B5,1,3,\"\")","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"RIGHT,REPT","index":8,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"RIGHT,SUBSTITUE,REPT Functions"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",{"$f":"RIGHT(SUBSTITUTE(B4,\"XYZ\",REPT(\"\",LEN(B4))),LEN(B4))","v":"Apple"},"North",4280]
[null,"XYZApricots",{"$f":"RIGHT(SUBSTITUTE(B5,\"XYZ\",REPT(\"\",LEN(B5))),LEN(B5))","v":"Apricots"},"East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"Text to Columns","index":9,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Text to Columns Option"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZ","Apple","North",4280]
[null,"XYZ","Apricots","East",4804]
[null,"XYZ","Banana","South",2476]
[null,"XYZ","Blackberries","North",2212]
[null,"XYZ","Blueberries","West",3930]
[null,"XYZ","Cherries","East",2227]
[null,"XYZ","Clementine","South",2411]

{"sheet":"VBA","index":10,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VBA Code"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple","Apple","North",4280]
[null,"XYZApricots","Apricots","East",4804]
[null,"XYZBanana","Banana","South",2476]
[null,"XYZBlackberries","Blackberries","North",2212]
[null,"XYZBlueberries","Blueberries","West",3930]
[null,"XYZCherries","Cherries","East",2227]
[null,"XYZClementine","Clementine","South",2411]

{"sheet":"Practice","index":11,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Practice"]
[]
[null,"Code","Product","Region","Sales"]
[null,"XYZApple",null,"North",4280]
[null,"XYZApricots",null,"East",4804]
[null,"XYZBanana",null,"South",2476]
[null,"XYZBlackberries",null,"North",2212]
[null,"XYZBlueberries",null,"West",3930]
[null,"XYZCherries",null,"East",2227]
[null,"XYZClementine",null,"South",2411]