{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Text to Columns","Keyboard Shortcuts","Fill Flash","VBA","Multiple Delimiters"],"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":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Text to Columns with Multiple Spaces"]
[]
[null,"Employee ID","Name City   Designation"]
[null,1612010,"Harry   Texas Manager"]
[null,1612011,"Emmy Toronto    Executive"]
[null,1612012,"Tom Montana Officer"]
[null,1612013,"Hermoine Texas    Accountant"]
[null,1612014,"Lily New-York   IT"]
[null,1612015,"Rose Texas   Engineer"]
[null,1612016,"Jack Montana   Human-Resources"]
[null,1612017,"Megh Toronto   Executive  "]
[null,1612018,"Moana Texas   Officer"]
[null,1612019,"Joe   New-York Engineer"]
[null,1612020,"Ron Washington   Officer"]

{"sheet":"Text to Columns","index":1,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Use of Text to Columns Feature",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee ID","Name","City","Designation",null,null,null,null,null,null,null,"Employee ID","Name City   Designation"]
[null,1612010,"Harry","Texas","Manager",null,null,null,null,null,null,null,1612010,"Harry   Texas Manager"]
[null,1612011,"Emmy","Toronto","Executive",null,null,null,null,null,null,null,1612011,"Emmy Toronto    Executive"]
[null,1612012,"Tom","Montana","Officer",null,null,null,null,null,null,null,1612012,"Tom Montana Officer"]
[null,1612013,"Hermoine","Texas","Accountant",null,null,null,null,null,null,null,1612013,"Hermoine Texas    Accountant"]
[null,1612014,"Lily","New-York","IT",null,null,null,null,null,null,null,1612014,"Lily New-York   IT"]
[null,1612015,"Rose","Texas","Engineer",null,null,null,null,null,null,null,1612015,"Rose Texas   Engineer"]
[null,1612016,"Jack","Montana","Human-Resources",null,null,null,null,null,null,null,1612016,"Jack Montana   Human-Resources"]
[null,1612017,"Megh","Toronto","Executive",null,null,null,null,null,null,null,1612017,"Megh Toronto   Executive  "]
[null,1612018,"Moana","Texas","Officer",null,null,null,null,null,null,null,1612018,"Moana Texas   Officer"]
[null,1612019,"Joe","New-York","Engineer",null,null,null,null,null,null,null,1612019,"Joe   New-York Engineer"]
[null,1612020,"Ron","Washington","Officer",null,null,null,null,null,null,null,1612020,"Ron Washington   Officer"]

{"sheet":"Keyboard Shortcuts","index":2,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Applying Keyboard Shortcuts",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee ID","Name","City","Designation",null,null,null,null,null,null,null,"Employee ID","Name City   Designation"]
[null,1612010,"Harry","Texas","Manager",null,null,null,null,null,null,null,1612010,"Harry   Texas Manager"]
[null,1612011,"Emmy","Toronto","Executive",null,null,null,null,null,null,null,1612011,"Emmy Toronto    Executive"]
[null,1612012,"Tom","Montana","Officer",null,null,null,null,null,null,null,1612012,"Tom Montana Officer"]
[null,1612013,"Hermoine","Texas","Accountant",null,null,null,null,null,null,null,1612013,"Hermoine Texas    Accountant"]
[null,1612014,"Lily","New-York","IT",null,null,null,null,null,null,null,1612014,"Lily New-York   IT"]
[null,1612015,"Rose","Texas","Engineer",null,null,null,null,null,null,null,1612015,"Rose Texas   Engineer"]
[null,1612016,"Jack","Montana","Human-Resources",null,null,null,null,null,null,null,1612016,"Jack Montana   Human-Resources"]
[null,1612017,"Megh","Toronto","Executive",null,null,null,null,null,null,null,1612017,"Megh Toronto   Executive  "]
[null,1612018,"Moana","Texas","Officer",null,null,null,null,null,null,null,1612018,"Moana Texas   Officer"]
[null,1612019,"Joe","New-York","Engineer",null,null,null,null,null,null,null,1612019,"Joe   New-York Engineer"]
[null,1612020,"Ron","Washington","Officer",null,null,null,null,null,null,null,1612020,"Ron Washington   Officer"]

{"sheet":"Fill Flash","index":3,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Employing Fill Flash Feature",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee ID","Name City Designation","Name","City","Designation",null,null,null,null,null,null,"Employee ID","Name City Designation"]
[null,1612010,"Harry Texas Manager","Harry","Texas","Manager",null,null,null,null,null,null,1612010,"Harry Texas Manager"]
[null,1612011,"Emmy Toronto Executive","Emmy","Toronto","Executive",null,null,null,null,null,null,1612011,"Emmy Toronto Executive"]
[null,1612012,"Tom Montana Officer","Tom","Montana","Officer",null,null,null,null,null,null,1612012,"Tom Montana Officer"]
[null,1612013,"Hermoine Texas Accountant","Hermoine","Texas","Accountant",null,null,null,null,null,null,1612013,"Hermoine Texas Accountant"]
[null,1612014,"Lily New-York IT","Lily","York","IT",null,null,null,null,null,null,1612014,"Lily New-York IT"]
[null,1612015,"Rose Texas Engineer","Rose","Texas","Engineer",null,null,null,null,null,null,1612015,"Rose Texas Engineer"]
[null,1612016,"Jack Montana Human-Resources","Jack","Human","Resources",null,null,null,null,null,null,1612016,"Jack Montana Human-Resources"]
[null,1612017,"Megh Toronto Executive","Megh","Toronto","Executive",null,null,null,null,null,null,1612017,"Megh Toronto Executive"]
[null,1612018,"Moana Texas Officer","Moana","Texas","Officer",null,null,null,null,null,null,1612018,"Moana Texas Officer"]
[null,1612019,"Joe New-York Engineer","Joe","York","Engineer",null,null,null,null,null,null,1612019,"Joe New-York Engineer"]
[null,1612020,"Ron Washington Officer","Ron","Washington","Officer",null,null,null,null,null,null,1612020,"Ron Washington Officer"]

{"sheet":"VBA","index":4,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Using VBA Code"]
[]
[null,"Employee ID","Name","City","Designation"]
[null,1612010,"Harry","Texas","Manager"]
[null,1612011,"Emmy","Toronto","Executive"]
[null,1612012,"Tom","Montana","Officer"]
[null,1612013,"Hermoine","Texas","Accountant"]
[null,1612014,"Lily","New-York","IT"]
[null,1612015,"Rose","Texas","Engineer"]
[null,1612016,"Jack","Montana","Human-Resources"]
[null,1612017,"Megh","Toronto","Executive"]
[null,1612018,"Moana","Texas","Officer"]
[null,1612019,"Joe","New-York","Engineer"]
[null,1612020,"Ron","Washington","Officer"]

{"sheet":"Multiple Delimiters","index":5,"n_rows":15,"n_cols":14,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,12,1,15]]}
[]
[null,"Applying Text to Columns Feature",null,null,null,null,null,null,null,null,null,null,"Do It Yourself"]
[]
[null,"Employee ID","Name","City","Designation",null,null,null,null,null,null,null,"Employee ID","Name City Designation"]
[null,1612010,"Harry","Texas","Manager",null,null,null,null,null,null,null,1612010,"Harry,Texas Manager"]
[null,1612011,"Emmy","Toronto","Executive",null,null,null,null,null,null,null,1612011,"Emmy,Toronto Executive"]
[null,1612012,"Tom","Montana","Officer",null,null,null,null,null,null,null,1612012,"Tom Montana Officer"]
[null,1612013,"Hermoine","Texas","Accountant",null,null,null,null,null,null,null,1612013,"Hermoine Texas,Accountant"]
[null,1612014,"Lily","New-York","IT",null,null,null,null,null,null,null,1612014,"Lily New-York,IT"]
[null,1612015,"Rose","Texas","Engineer",null,null,null,null,null,null,null,1612015,"Rose Texas Engineer"]
[null,1612016,"Jack","Montana","Human-Resources",null,null,null,null,null,null,null,1612016,"Jack Montana Human-Resources"]
[null,1612017,"Megh","Toronto","Executive",null,null,null,null,null,null,null,1612017,"Megh Toronto Executive"]
[null,1612018,"Moana","Texas","Officer",null,null,null,null,null,null,null,1612018,"Moana,Texas Officer"]
[null,1612019,"Joe","New-York","Engineer",null,null,null,null,null,null,null,1612019,"Joe New-York Engineer"]
[null,1612020,"Ron","Washington","Officer",null,null,null,null,null,null,null,1612020,"Ron Washington Officer"]