{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Dataset","LEFT Function for Last Char","LEFT Function for Multiple Char","VALUE Function","VBA","Flash Fill","MID Function","Practice","Practice (2)"],"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":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Excel Remove Characters From Right"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer"]
[null,"Chandler29002","24Comics"]
[null,"Jhon39400","24Laptop"]
[null,"Anderson43200","13Smartphone"]
[null,"Jonas29005","14Album"]
[null,"Rachel32005","15Dress"]
[null,"Ross43200","20Book"]

{"sheet":"LEFT Function for Last Char","index":1,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using LEFT Function"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer",{"$f":"LEFT(B4,LEN(B4)-1)","v":"Steve2900"}]
[null,"Chandler29002","24Comics",{"$f":"LEFT(B5,LEN(B5)-1)","v":"Chandler2900"}]
[null,"Jhon39400","24Laptop",{"$f":"LEFT(B6,LEN(B6)-1)","v":"Jhon3940"}]
[null,"Anderson43200","13Smartphone","Anderson4320"]
[null,"Jonas29005","14Album","Jonas2900"]
[null,"Rachel32005","15Dress","Rachel3200"]
[null,"Ross43200","20Book",{"$f":"LEFT(B10,LEN(B10)-1)","v":"Ross4320"}]

{"sheet":"LEFT Function for Multiple Char","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Excel Remove Characters From Right"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer",{"$f":"LEFT(B4,LEN(B4)-5)","v":"Steve"},{"$f":"LEFT(C4,LEN(C4)-5)","v":"32Com"}]
[null,"Chandler29002","24Comics",{"$f":"LEFT(B5,LEN(B5)-5)","v":"Chandler"}]
[null,"Jhon39400","24Laptop","Jhon"]
[null,"Anderson43200","13Smartphone","Anderson"]
[null,"Jonas29005","14Album","Jonas"]
[null,"Rachel32005","15Dress","Rachel"]
[null,"Ross43200","20Book","Ross"]

{"sheet":"VALUE Function","index":3,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Value Function"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer",{"$f":"'Flash Fill'!D4","v":"Steve"},{"$f":"VALUE(LEFT(C4,(LEN(C4)-8)))","v":32}]
[null,"Chandler29002","24Comics",{"$f":"LEFT(B5,LEN(B5)-5)","v":"Chandler"}]
[null,"Jhon39400","24Laptop","Jhon"]
[null,"Anderson43200","13Smartphone","Anderson",{"$f":"VALUE(LEFT(C7,(LEN(C7)-10)))","v":13}]
[null,"Jonas29005","14Album","Jonas"]
[null,"Rachel32005","15Dress","Rachel"]
[null,"Ross43200","20Book","Ross",{"$f":"VALUE(LEFT(C10,(LEN(C10)-4)))","v":20}]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using VBA"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer",{"$f":"RemoveRightCharacter(B4,5)","v":"Steve"},{"$f":"RemoveRightCharacter(C4,8)","v":"32"}]
[null,"Chandler29002","24Comics",{"$f":"RemoveRightCharacter(B5,5)","v":"Chandler"},{"$f":"RemoveRightCharacter(C5,6)","v":"24"}]
[null,"Jhon39400","24Laptop",{"$f":"RemoveRightCharacter(B6,5)","v":"Jhon"},{"$f":"RemoveRightCharacter(C6,6)","v":"24"}]
[null,"Anderson43200","13Smartphone",{"$f":"RemoveRightCharacter(B7,5)","v":"Anderson"},{"$f":"RemoveRightCharacter(C7,10)","v":"13"}]
[null,"Jonas29005","14Album",{"$f":"RemoveRightCharacter(B8,5)","v":"Jonas"},{"$f":"RemoveRightCharacter(C8,5)","v":"14"}]
[null,"Rachel32005","15Dress",{"$f":"RemoveRightCharacter(B9,5)","v":"Rachel"},{"$f":"RemoveRightCharacter(C9,5)","v":"15"}]
[null,"Ross43200","20Book",{"$f":"RemoveRightCharacter(B10,5)","v":"Ross"},{"$f":"RemoveRightCharacter(C10,4)","v":"20"}]

{"sheet":"Flash Fill","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using Flash Fill"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer","Steve",32]
[null,"Chandler29002","24Comics","Chandler",24]
[null,"Jhon39400","24Laptop","Jhon",24]
[null,"Anderson43200","13Smartphone","Anderson",13]
[null,"Jonas29005","14Album","Jonas",14]
[null,"Rachel32005","15Dress","Rachel",15]
[null,"Ross43200","20Book","Ross",20]

{"sheet":"MID Function","index":6,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Using MID Function"]
[]
[null,"Name, ID and Order","Order ","Name"]
[null,"32Computer_Steve29001","32Computer",{"$f":"MID(B4, 11+1, LEN(B4) - (10+6))","v":"Steve"}]
[null,"24Comics_Chandler29002","24Comics",{"$f":"MID(B5, 9+1, LEN(B5) - (9+5))","v":"Chandler"}]
[null,"24Laptop_Jhon39400","24Laptop",{"$f":"MID(B6, 9+1, LEN(B6) - (9+5))","v":"Jhon"}]
[null,"13Smartphone_Anderson43200","13Smartphone",{"$f":"MID(B7, 13+1, LEN(B7) - (11+7))","v":"Anderson"}]
[null,"14Album_Jonas29005","14Album",{"$f":"MID(B8, 8+1, LEN(B8) - (8+5))","v":"Jonas"}]
[null,"15Dress_Rachel32005","15Dress",{"$f":"MID(B9, 8+1, LEN(B9) - (8+5))","v":"Rachel"}]
[null,"20Book_Ross43200","20Book",{"$f":"MID(B10, 7+1, LEN(B10) - (7+5))","v":"Ross"}]

{"sheet":"Practice","index":7,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Do it Yourself"]
[]
[null,"Name with ID","Order ","Name","Order Quantity"]
[null,"Steve29001","32Computer"]
[null,"Chandler29002","24Comics"]
[null,"Jhon39400","24Laptop"]
[null,"Anderson43200","13Smartphone"]
[null,"Jonas29005","14Album"]
[null,"Rachel32005","15Dress"]
[null,"Ross43200","20Book"]

{"sheet":"Practice (2)","index":8,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[0,1,0,4]]}
[null,"Do it Yourself"]
[]
[null,"Name, ID and Order","Order ","Name"]
[null,"32Computer_Steve29001","32Computer"]
[null,"24Comics_Chandler29002","24Comics"]
[null,"24Laptop_Jhon39400","24Laptop"]
[null,"13Smartphone_Anderson43200","13Smartphone"]
[null,"14Album_Jonas29005","14Album"]
[null,"15Dress_Rachel32005","15Dress"]
[null,"20Book_Ross43200","20Book"]