{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["REPLACE","VBA code","Flash and Fill","LEFT and LEN","Remove from Left"],"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":"REPLACE","index":0,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Last 3 Characters",null,null,null,null,"Practice"]
[]
[null,"Product ID","Different Types of Tea"," Tea",null,null,"Product ID","Different Types of Tea"," Tea"]
[null,110,"Green Tea",{"$f":"REPLACE(C6, FIND(\" \",C6)+1, 3, \"\")","v":"Green "},null,null,110,"Green Tea"]
[null,{"$f":"B6+1","v":111},"Black Tea",{"$f":"REPLACE(C7, FIND(\" \",C7)+1, 3, \"\")","v":"Black "},null,null,{"$f":"G6+1","v":111},"Black Tea"]
[null,{"$f":"B7+1","v":112},"Jasmine Tea","Jasmine ",null,null,{"$f":"G7+1","v":112},"Jasmine Tea"]
[null,113,"Herbal Tea","Herbal ",null,null,113,"Herbal Tea"]
[null,114,"Hibiscus Tea","Hibiscus ",null,null,114,"Hibiscus Tea"]

{"sheet":"VBA code","index":1,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Last 3 Characters",null,null,null,null,"Practice"]
[]
[null,"Product ID","Different Types of Tea"," Tea",null,null,"Product ID","Different Types of Tea"," Tea"]
[null,110,"Green Tea",{"$f":"Remove_Last_3_Characters(C6,3)","v":"Green "},null,null,110,"Green Tea",{"$f":"REPLACE(H6, FIND(\" \",H6)+1, 3, \"\")","v":"Green "}]
[null,{"$f":"B6+1","v":111},"Black Tea",null,null,null,{"$f":"G6+1","v":111},"Black Tea",{"$f":"REPLACE(H7, FIND(\" \",H7)+1, 3, \"\")","v":"Black "}]
[null,{"$f":"B7+1","v":112},"Jasmine Tea",null,null,null,{"$f":"G7+1","v":112},"Jasmine Tea","Jasmine "]
[null,113,"Herbal Tea",null,null,null,113,"Herbal Tea","Herbal "]
[null,114,"Hibiscus Tea",null,null,null,114,"Hibiscus Tea","Hibiscus "]

{"sheet":"Flash and Fill","index":2,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Last 3 Characters",null,null,null,null,"Practice"]
[]
[null,"Product ID","Different Types of Tea"," Tea",null,null,"Product ID","Different Types of Tea"," Tea"]
[null,110,"Green Tea","Green",null,null,110,"Green Tea"]
[null,{"$f":"B6+1","v":111},"Black Tea","Black",null,null,{"$f":"G6+1","v":111},"Black Tea"]
[null,{"$f":"B7+1","v":112},"Jasmine Tea","Jasmine",null,null,{"$f":"G7+1","v":112},"Jasmine Tea"]
[null,113,"Herbal Tea","Herbal",null,null,113,"Herbal Tea"]
[null,114,"Hibiscus Tea","Hibiscus",null,null,114,"Hibiscus Tea"]

{"sheet":"LEFT and LEN","index":3,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Last 3 Characters",null,null,null,null,"Practice"]
[]
[null,"Product ID","Different Types of Tea"," Tea",null,null,"Product ID","Different Types of Tea"," Tea"]
[null,110,"Green Tea",{"$f":"LEFT(C6,LEN(C6)-3)","v":"Green "},null,null,110,"Green Tea"]
[null,{"$f":"B6+1","v":111},"Black Tea",{"$f":"LEFT(C7,LEN(C7)-3)","v":"Black "},null,null,{"$f":"G6+1","v":111},"Black Tea"]
[null,{"$f":"B7+1","v":112},"Jasmine Tea","Jasmine ",null,null,{"$f":"G7+1","v":112},"Jasmine Tea"]
[null,113,"Herbal Tea","Herbal ",null,null,113,"Herbal Tea"]
[null,114,"Hibiscus Tea","Hibiscus ",null,null,114,"Hibiscus Tea"]

{"sheet":"Remove from Left","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,3],[2,6,2,8]]}
[]
[]
[null,"Removing Characters from Left",null,null,null,null,"Practice"]
[]
[null,"Product ID","Different Types of Tea","Product Category",null,null,"Product ID","Different Types of Tea","Product Category"]
[null,110,"Green Tea",{"$f":"RIGHT(TRIM(C6),LEN(TRIM(C6))-FIND(\" \",TRIM(C6)))","v":"Tea"},null,null,110,"Green Tea"]
[null,{"$f":"B6+1","v":111},"Black Tea",{"$f":"RIGHT(TRIM(C7),LEN(TRIM(C7))-FIND(\" \",TRIM(C7)))","v":"Tea"},null,null,{"$f":"G6+1","v":111},"Black Tea"]
[null,{"$f":"B7+1","v":112},"Jasmine Tea","Tea",null,null,{"$f":"G7+1","v":112},"Jasmine Tea"]
[null,113,"Herbal Tea","Tea",null,null,113,"Herbal Tea"]
[null,114,"Hibiscus Tea","Tea",null,null,114,"Hibiscus Tea"]