{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Method 1","Method 2","Method 3","LEFT and RIGHT Functions","LEFT, RIGHT and VALUE Functions"],"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":"Method 1","index":0,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using Flash Fill Command",null,null,null,"Try Yourself"]
[]
[null,"Customer Name, ID and Order","Order","Customer Name",null,"Customer Name, ID and Order","Order","Customer Name"]
[null,"57Book_Adam1610","57Book","Adam",null,"57Book_Adam1610","57Book"]
[null,"43Laptop_Ron1645","43Laptop","Ron",null,"43Laptop_Ron1645","43Laptop"]
[null,"23Computer_David1625","23Computer","David",null,"23Computer_David1625","23Computer"]
[null,"17Magazine_Lily1654","17Magazine","Lily",null,"17Magazine_Lily1654","17Magazine"]
[null,"20Smartphone_Daniel1615","20Smartphone","Daniel",null,"20Smartphone_Daniel1615","20Smartphone"]
[null,"30Dress_Rebecca1605","30Dress","Rebecca",null,"30Dress_Rebecca1605","30Dress"]
[null,"25Perfume_Robert1618","25Perfume","Robert",null,"25Perfume_Robert1618","25Perfume"]

{"sheet":"Method 2","index":1,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Using MID Function",null,null,null,"Try Yourself"]
[]
[null,"Customer Name, ID and Order","Order","Customer Name",null,"Customer Name, ID and Order","Order","Customer Name"]
[null,"57Book_Adam1610","57Book",{"$f":"MID(B5,7+1,LEN(B5)-(7+4))","v":"Adam"},null,"57Book_Adam1610","57Book"]
[null,"43Laptop_Ron1645","43Laptop",{"$f":"MID(B6,9+1,LEN(B6)-(9+4))","v":"Ron"},null,"43Laptop_Ron1645","43Laptop"]
[null,"23Computer_David1625","23Computer",{"$f":"MID(B7,11+1,LEN(B7)-(11+4))","v":"David"},null,"23Computer_David1625","23Computer"]
[null,"17Magazine_Lily1654","17Magazine",{"$f":"MID(B8,11+1,LEN(B8)-(11+4))","v":"Lily"},null,"17Magazine_Lily1654","17Magazine"]
[null,"20Smartphone_Daniel1615","20Smartphone",{"$f":"MID(B9,13+1,LEN(B9)-(13+4))","v":"Daniel"},null,"20Smartphone_Daniel1615","20Smartphone"]
[null,"30Dress_Rebecca1605","30Dress",{"$f":"MID(B10,8+1,LEN(B10)-(8+4))","v":"Rebecca"},null,"30Dress_Rebecca1605","30Dress"]
[null,"25Perfume_Robert1618","25Perfume",{"$f":"MID(B11,10+1,LEN(B11)-(10+4))","v":"Robert"},null,"25Perfume_Robert1618","25Perfume"]

{"sheet":"Method 3","index":2,"n_rows":11,"n_cols":8,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Employing VBA Codes",null,null,null,"Try Yourself"]
[]
[null,"Customer Name, ID and Order","Order","Customer Name",null,"Customer Name, ID and Order","Order","Customer Name"]
[null,"57Book_Adam1610","57Book",{"$f":"RemoveCharacters(B5,7,4)","v":"Adam"},null,"57Book_Adam1610","57Book"]
[null,"43Laptop_Ron1645","43Laptop",{"$f":"RemoveCharacters(B6,9,4)","v":"Ron"},null,"43Laptop_Ron1645","43Laptop"]
[null,"23Computer_David1625","23Computer",{"$f":"RemoveCharacters(B7,11,4)","v":"David"},null,"23Computer_David1625","23Computer"]
[null,"17Magazine_Lily1654","17Magazine",{"$f":"RemoveCharacters(B8,11,4)","v":"Lily"},null,"17Magazine_Lily1654","17Magazine"]
[null,"20Smartphone_Daniel1615","20Smartphone",{"$f":"RemoveCharacters(B9,13,4)","v":"Daniel"},null,"20Smartphone_Daniel1615","20Smartphone"]
[null,"30Dress_Rebecca1605","30Dress",{"$f":"RemoveCharacters(B10,8,4)","v":"Rebecca"},null,"30Dress_Rebecca1605","30Dress"]
[null,"25Perfume_Robert1618","25Perfume",{"$f":"RemoveCharacters(B11,10,4)","v":"Robert"},null,"25Perfume_Robert1618","25Perfume"]

{"sheet":"LEFT and RIGHT Functions","index":3,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Applying LEFT and RIGHT Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Product Quantity with Name","Product Name","Customer Name with ID","Customer Name",null,"Product Quantity with Name","Product Name","Customer Name with ID","Customer Name"]
[null,"57Book",{"$f":"RIGHT(B5,LEN(B5)-2)","v":"Book"},"Adam1610",{"$f":"LEFT(D5,LEN(D5)-4)","v":"Adam"},null,"57Book",null,"Adam1610"]
[null,"43Laptop",{"$f":"RIGHT(B6,LEN(B6)-2)","v":"Laptop"},"Ron1645",{"$f":"LEFT(D6,LEN(D6)-4)","v":"Ron"},null,"43Laptop",null,"Ron1645"]
[null,"23Computer","Computer","David1625","David",null,"23Computer",null,"David1625"]
[null,"17Magazine","Magazine","Lily1654","Lily",null,"17Magazine",null,"Lily1654"]
[null,"20Smartphone","Smartphone","Daniel1615","Daniel",null,"20Smartphone",null,"Daniel1615"]
[null,"30Dress","Dress","Rebecca1605","Rebecca",null,"30Dress",null,"Rebecca1605"]
[null,"25Perfume","Perfume","Robert1618","Robert",null,"25Perfume",null,"Robert1618"]

{"sheet":"LEFT, RIGHT and VALUE Functions","index":4,"n_rows":11,"n_cols":10,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,9]]}
[]
[null,"Combining LEFT, RIGHT and VALUE Functions",null,null,null,null,"Try Yourself"]
[]
[null,"Product Quantity with Name","Product Quantity","Customer Name with ID","Customer ID",null,"Product Quantity with Name","Product Quantity","Customer Name with ID","Customer ID"]
[null,"57Book",{"$f":"VALUE(LEFT(B5,(LEN(B5)-4)))","v":57},"Adam1610",{"$f":"VALUE(RIGHT(D5,(LEN(D5)-4)))","v":1610},null,"57Book",null,"Adam1610"]
[null,"43Laptop",{"$f":"VALUE(LEFT(B6,(LEN(B6)-6)))","v":43},"Ron1645",{"$f":"VALUE(RIGHT(D6,(LEN(D6)-3)))","v":1645},null,"43Laptop",null,"Ron1645"]
[null,"23Computer",{"$f":"VALUE(LEFT(B7,(LEN(B7)-8)))","v":23},"David1625",{"$f":"VALUE(RIGHT(D7,(LEN(D7)-5)))","v":1625},null,"23Computer",null,"David1625"]
[null,"17Magazine",{"$f":"VALUE(LEFT(B8,(LEN(B8)-8)))","v":17},"Lily1654",{"$f":"VALUE(RIGHT(D8,(LEN(D8)-4)))","v":1654},null,"17Magazine",null,"Lily1654"]
[null,"20Smartphone",{"$f":"VALUE(LEFT(B9,(LEN(B9)-10)))","v":20},"Daniel1615",{"$f":"VALUE(RIGHT(D9,(LEN(D9)-6)))","v":1615},null,"20Smartphone",null,"Daniel1615"]
[null,"30Dress",{"$f":"VALUE(LEFT(B10,(LEN(B10)-5)))","v":30},"Rebecca1605",{"$f":"VALUE(RIGHT(D10,(LEN(D10)-7)))","v":1605},null,"30Dress",null,"Rebecca1605"]
[null,"25Perfume",{"$f":"VALUE(LEFT(B11,(LEN(B11)-7)))","v":25},"Robert1618",{"$f":"VALUE(RIGHT(D11,(LEN(D11)-6)))","v":1618},null,"25Perfume",null,"Robert1618"]