{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Convert Text to Columns Wizard","LEFT, RIGHT, FIND, and LEN ","Dynamic Array Formula","Flash Fill","CSV File Format","VBA","Power Query","Power Pivot","Practice Section","Power Query (2)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Convert Text to Columns Wizard","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Convert Text to Columns Wizard"]
[]
[null,"Country with Capital City","Country","Capital City"]
[null,"Finland, Helsinki","Finland"," Helsinki"]
[null,"France, Paris","France"," Paris"]
[null,"Gabon, Libreville","Gabon"," Libreville"]
[null,"Gambia, Banjul","Gambia"," Banjul"]
[null,"Georgia, Tbilisi","Georgia"," Tbilisi"]
[null,"Germany, Berlin","Germany"," Berlin"]
[null,"Ghana, Accra","Ghana"," Accra"]
[null,"Greece, Athens","Greece"," Athens"]

{"sheet":"LEFT, RIGHT, FIND, and LEN ","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using LEFT, RIGHT, FIND, and LEN Functions"]
[]
[null,"Country with Capital City","Country","Capital City"]
[null,"Finland, Helsinki",{"$f":"LEFT(B5,FIND(\",\",B5)-1)","v":"Finland"},{"$f":"RIGHT(B5,LEN(B5)-FIND(\",\",B5))","v":" Helsinki"}]
[null,"France, Paris",{"$f":"LEFT(B6,FIND(\",\",B6)-1)","v":"France"},{"$f":"RIGHT(B6,LEN(B6)-FIND(\",\",B6))","v":" Paris"}]
[null,"Gabon, Libreville","Gabon"," Libreville"]
[null,"Gambia, Banjul","Gambia"," Banjul"]
[null,"Georgia, Tbilisi","Georgia"," Tbilisi"]
[null,"Germany, Berlin","Germany"," Berlin"]
[null,"Ghana, Accra","Ghana"," Accra"]
[null,"Greece, Athens","Greece"," Athens"]

{"sheet":"Dynamic Array Formula","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Dynamic Array Formula"]
[]
[null,"Country with Capital City","Country","Capital City"]
[null,"Finland, Helsinki",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B5,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Finland"},"Helsinki"]
[null,"France, Paris",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B6,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"France"},"Paris"]
[null,"Gabon, Libreville",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B7,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Gabon"},"Libreville"]
[null,"Gambia, Banjul",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B8,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Gambia"},"Banjul"]
[null,"Georgia, Tbilisi",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B9,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Georgia"},"Tbilisi"]
[null,"Germany, Berlin",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B10,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Germany"},"Berlin"]
[null,"Ghana, Accra",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B11,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Ghana"},"Accra"]
[null,"Greece, Athens",{"$f":"TRANSPOSE(_xlfn.FILTERXML(\"<t><s>\" &SUBSTITUTE(B12,\",\",\"</s><s>\") & \"</s></t>\",\"//s\"))","v":"Greece"},"Athens"]

{"sheet":"Flash Fill","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Flash Fill"]
[]
[null,"Country with Capital City","Country","Capital City"]
[null,"Finland, Helsinki","Finland","Helsinki"]
[null,"France, Paris","France","Paris"]
[null,"Gabon, Libreville","Gabon","Libreville"]
[null,"Gambia, Banjul","Gambia","Banjul"]
[null,"Georgia, Tbilisi","Georgia","Tbilisi"]
[null,"Germany, Berlin","Germany","Berlin"]
[null,"Ghana, Accra","Ghana","Accra"]
[null,"Greece, Athens","Greece","Athens"]

{"sheet":"CSV File Format","index":4,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using CSV File Format"]
[]
[null,"Country with Capital City"]
[null,"Finland, Helsinki"]
[null,"France, Paris"]
[null,"Gabon, Libreville"]
[null,"Gambia, Banjul"]
[null,"Georgia, Tbilisi"]
[null,"Germany, Berlin"]
[null,"Ghana, Accra"]
[null,"Greece, Athens"]

{"sheet":"VBA","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using VBA Code"]
[]
[null,"Country with Capital City","Country","Capital City"]
[null,"Finland, Helsinki","Finland"," Helsinki"]
[null,"France, Paris","France"," Paris"]
[null,"Gabon, Libreville","Gabon"," Libreville"]
[null,"Gambia, Banjul","Gambia"," Banjul"]
[null,"Georgia, Tbilisi","Georgia"," Tbilisi"]
[null,"Germany, Berlin","Germany"," Berlin"]
[null,"Ghana, Accra","Ghana"," Accra"]
[null,"Greece, Athens","Greece"," Athens"]

{"sheet":"Power Query","index":6,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Power Query"]
[]
[null,"Country with Capital City"]
[null,"Finland, Helsinki"]
[null,"France, Paris"]
[null,"Gabon, Libreville"]
[null,"Gambia, Banjul"]
[null,"Georgia, Tbilisi"]
[null,"Germany, Berlin"]
[null,"Ghana, Accra"]
[null,"Greece, Athens"]

{"sheet":"Power Pivot","index":7,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Using Power Pivot"]
[]
[null,"Country with Capital City"]
[null,"Finland, Helsinki"]
[null,"France, Paris"]
[null,"Gabon, Libreville"]
[null,"Gambia, Banjul"]
[null,"Georgia, Tbilisi"]
[null,"Germany, Berlin"]
[null,"Ghana, Accra"]
[null,"Greece, Athens"]

{"sheet":"Practice Section","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Practice Here"]
[]
[null,"Country with Capital City","Country","Capital City"]
[null,"Finland, Helsinki"]
[null,"France, Paris"]
[null,"Gabon, Libreville"]
[null,"Gambia, Banjul"]
[null,"Georgia, Tbilisi"]
[null,"Germany, Berlin"]
[null,"Ghana, Accra"]
[null,"Greece, Athens"]

{"sheet":"Power Query (2)","index":9,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Column1.1","Column1.2"]
["Using Power Query"]
[]
["Country with Capital City"]
["Finland"," Helsinki"]
["France"," Paris"]
["Gabon"," Libreville"]
["Gambia"," Banjul"]
["Georgia"," Tbilisi"]
["Germany"," Berlin"]
["Ghana"," Accra"]
["Greece"," Athens"]