{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset-1","Text to Columns","TRIM, MID, SUBSTITUTE, REPT","Dataset-2","LEFT, RIGHT, MID, LEN, and FIND","Flash Fill","Power Query","VBA Code"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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-1","index":0,"n_rows":13,"n_cols":2,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Best Sellers"]
[]
[null,"Book Name, Author, Genre"]
[null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]
[null,"Sapiens, Noah Harari, History"]
[null,"Atomic Habits, James Clear, Self Help"]
[null,"Prisoners of Geography, Tim Marshall, Geography"]

{"sheet":"Text to Columns","index":1,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Text to Columns Feature",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name, Author, Genre","Book Name","Author","Genre",null,null,null,null,null,null,"Book Name, Author, Genre","Book Name","Author","Genre"]
[null,"Poor Economics, Abhijit Banarjee, Economics","Poor Economics"," Abhijit Banarjee"," Economics",null,null,null,null,null,null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom, Jim Khalili, History","House of Wisdom"," Jim Khalili"," History",null,null,null,null,null,null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow, Seth Godin, Marketing","Purple Cow"," Seth Godin"," Marketing",null,null,null,null,null,null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick, Chip Heath, Self Help","Made to Stick"," Chip Heath"," Self Help",null,null,null,null,null,null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan, Nassim Taleb, Philosophy","The Black Swan"," Nassim Taleb"," Philosophy",null,null,null,null,null,null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow, Daniel Kahneman, Psychology","Thinking Fast and Slow"," Daniel Kahneman"," Psychology",null,null,null,null,null,null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]
[null,"Sapiens, Noah Harari, History","Sapiens"," Noah Harari"," History",null,null,null,null,null,null,"Sapiens, Noah Harari, History"]
[null,"Atomic Habits, James Clear, Self Help","Atomic Habits"," James Clear"," Self Help",null,null,null,null,null,null,"Atomic Habits, James Clear, Self Help"]
[null,"Prisoners of Geography, Tim Marshall, Geography","Prisoners of Geography"," Tim Marshall"," Geography",null,null,null,null,null,null,"Prisoners of Geography, Tim Marshall, Geography"]

{"sheet":"TRIM, MID, SUBSTITUTE, REPT","index":2,"n_rows":14,"n_cols":15,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[3,1,4,1],[1,11,1,14],[3,11,4,11]]}
[]
[null,"Using TRIM, MID, SUBSTITUTE, REPT, and LEN Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name, Author, Genre","Book Name","Author","Genre",null,null,null,null,null,null,"Book Name, Author, Genre","Book Name","Author","Genre"]
[null,null,1,2,3,null,null,null,null,null,null,null,1,2,3]
[null,"Poor Economics, Abhijit Banarjee, Economics",{"$f":"TRIM(MID(SUBSTITUTE($B6,\",\",REPT(\" \",LEN($B6))),(C$5-1)*LEN($B6)+1,LEN($B6)))","v":"Poor Economics"},{"$f":"TRIM(MID(SUBSTITUTE($B6,\",\",REPT(\" \",LEN($B6))),(D$5-1)*LEN($B6)+1,LEN($B6)))","v":"Abhijit Banarjee"},"Economics",null,null,null,null,null,null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom, Jim Khalili, History",{"$f":"TRIM(MID(SUBSTITUTE($B7,\",\",REPT(\" \",LEN($B7))),(C$5-1)*LEN($B7)+1,LEN($B7)))","v":"House of Wisdom"},"Jim Khalili","History",null,null,null,null,null,null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow, Seth Godin, Marketing","Purple Cow","Seth Godin","Marketing",null,null,null,null,null,null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick, Chip Heath, Self Help","Made to Stick","Chip Heath","Self Help",null,null,null,null,null,null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan, Nassim Taleb, Philosophy","The Black Swan","Nassim Taleb","Philosophy",null,null,null,null,null,null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow, Daniel Kahneman, Psychology","Thinking Fast and Slow","Daniel Kahneman","Psychology",null,null,null,null,null,null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]
[null,"Sapiens, Noah Harari, History","Sapiens","Noah Harari","History",null,null,null,null,null,null,"Sapiens, Noah Harari, History"]
[null,"Atomic Habits, James Clear, Self Help","Atomic Habits","James Clear","Self Help",null,null,null,null,null,null,"Atomic Habits, James Clear, Self Help"]
[null,"Prisoners of Geography, Tim Marshall, Geography","Prisoners of Geography","Tim Marshall","Geography",null,null,null,null,null,null,"Prisoners of Geography, Tim Marshall, Geography"]

{"sheet":"Dataset-2","index":3,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"List of Clientele"]
[]
[null,"Name, Country, and City"]
[null,"Trevor; Iceland@ Reykjavik"]
[null,"Olivia; France@ Nice"]
[null,"Eli; Germany@ Munich"]
[null,"Paul; England@ Dover"]
[null,"William; USA@ Chicago"]
[null,"Benny; Turkey@ Istanbul"]
[null,"Lucas; Greece@ Athens"]
[null,"Hans; Austria@ Vienna"]

{"sheet":"LEFT, RIGHT, MID, LEN, and FIND","index":4,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using LEFT, RIGHT, MID, LEN, and FIND Functions",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name, Country, and City","Name","Country","City",null,null,null,null,null,null,"Name, Country, and City","Name","Country","City"]
[null,"Trevor; Iceland@ Reykjavik",{"$f":"LEFT(B5,FIND(\";\",B5)-1)","v":"Trevor"},{"$f":"MID(B5,FIND(\";\",B5)+1,FIND(\"@\",B5)-FIND(\";\",B5)-1)","v":" Iceland"},{"$f":"RIGHT(B5,LEN(B5)-FIND(\"@\",B5))","v":" Reykjavik"},null,null,null,null,null,null,"Trevor; Iceland@ Reykjavik"]
[null,"Olivia; France@ Nice",{"$f":"LEFT(B6,FIND(\";\",B6)-1)","v":"Olivia"},{"$f":"MID(B6,FIND(\";\",B6)+1,FIND(\"@\",B6)-FIND(\";\",B6)-1)","v":" France"},{"$f":"RIGHT(B6,LEN(B6)-FIND(\"@\",B6))","v":" Nice"},null,null,null,null,null,null,"Olivia; France@ Nice"]
[null,"Eli; Germany@ Munich","Eli"," Germany"," Munich",null,null,null,null,null,null,"Eli; Germany@ Munich"]
[null,"Paul; England@ Dover","Paul"," England"," Dover",null,null,null,null,null,null,"Paul; England@ Dover"]
[null,"William; USA@ Chicago","William"," USA"," Chicago",null,null,null,null,null,null,"William; USA@ Chicago"]
[null,"Benny; Turkey@ Istanbul","Benny"," Turkey"," Istanbul",null,null,null,null,null,null,"Benny; Turkey@ Istanbul"]
[null,"Lucas; Greece@ Athens","Lucas"," Greece"," Athens",null,null,null,null,null,null,"Lucas; Greece@ Athens"]
[null,"Hans; Austria@ Vienna","Hans"," Austria"," Vienna",null,null,null,null,null,null,"Hans; Austria@ Vienna"]

{"sheet":"Flash Fill","index":5,"n_rows":12,"n_cols":15,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Using Flash Fill Option",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Name, Country, and City","Name","Country","City",null,null,null,null,null,null,"Name, Country, and City","Name","Country","City"]
[null,"Trevor; Iceland@ Reykjavik","Trevor","Iceland","Reykjavik",null,null,null,null,null,null,"Trevor; Iceland@ Reykjavik"]
[null,"Olivia; France@ Nice","Olivia","France","Nice",null,null,null,null,null,null,"Olivia; France@ Nice"]
[null,"Eli; Germany@ Munich","Eli","Germany","Munich",null,null,null,null,null,null,"Eli; Germany@ Munich"]
[null,"Paul; England@ Dover","Paul","England","Dover",null,null,null,null,null,null,"Paul; England@ Dover"]
[null,"William; USA@ Chicago","William","USA","Chicago",null,null,null,null,null,null,"William; USA@ Chicago"]
[null,"Benny; Turkey@ Istanbul","Benny","Turkey","Istanbul",null,null,null,null,null,null,"Benny; Turkey@ Istanbul"]
[null,"Lucas; Greece@ Athens","Lucas","Greece","Athens",null,null,null,null,null,null,"Lucas; Greece@ Athens"]
[null,"Hans; Austria@ Vienna","Hans","Austria","Vienna",null,null,null,null,null,null,"Hans; Austria@ Vienna"]

{"sheet":"Power Query","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Power Query"]
[]
[null,"Name","Country","City"]
[null,"Trevor"," Iceland"," Reykjavik"]
[null,"Olivia"," France"," Nice"]
[null,"Eli"," Germany"," Munich"]
[null,"Paul"," England"," Dover"]
[null,"William"," USA"," Chicago"]
[null,"Benny"," Turkey"," Istanbul"]
[null,"Lucas"," Greece"," Athens"]
[null,"Hans"," Austria"," Vienna"]

{"sheet":"VBA Code","index":7,"n_rows":13,"n_cols":15,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,11,1,14]]}
[]
[null,"Applying VBA code",null,null,null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Book Name, Author, Genre","Book Name","Author","Genre",null,null,null,null,null,null,"Book Name, Author, Genre","Book Name","Author","Genre"]
[null,"Poor Economics; Abhijit Banarjee; Economics","Poor Economics"," Abhijit Banarjee"," Economics",null,null,null,null,null,null,"Poor Economics, Abhijit Banarjee, Economics"]
[null,"House of Wisdom; Jim Khalili; History","House of Wisdom"," Jim Khalili"," History",null,null,null,null,null,null,"House of Wisdom, Jim Khalili, History"]
[null,"Purple Cow; Seth Godin; Marketing","Purple Cow"," Seth Godin"," Marketing",null,null,null,null,null,null,"Purple Cow, Seth Godin, Marketing"]
[null,"Made to Stick; Chip Heath; Self Help","Made to Stick"," Chip Heath"," Self Help",null,null,null,null,null,null,"Made to Stick, Chip Heath, Self Help"]
[null,"The Black Swan; Nassim Taleb; Philosophy","The Black Swan"," Nassim Taleb"," Philosophy",null,null,null,null,null,null,"The Black Swan, Nassim Taleb, Philosophy"]
[null,"Thinking Fast and Slow; Daniel Kahneman; Psychology","Thinking Fast and Slow"," Daniel Kahneman"," Psychology",null,null,null,null,null,null,"Thinking Fast and Slow, Daniel Kahneman, Psychology"]
[null,"Sapiens; Noah Harari; History","Sapiens"," Noah Harari"," History",null,null,null,null,null,null,"Sapiens, Noah Harari, History"]
[null,"Atomic Habits; James Clear; Self Help","Atomic Habits"," James Clear"," Self Help",null,null,null,null,null,null,"Atomic Habits, James Clear, Self Help"]
[null,"Prisoners of Geography; Tim Marshall; Geography","Prisoners of Geography"," Tim Marshall"," Geography",null,null,null,null,null,null,"Prisoners of Geography, Tim Marshall, Geography"]