{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Dataset","Column Wizard","Flash Fill","Combined Functions","TRANSPOSE","VBA","Power Query","TEXTBEFORE & TEXTAFTER","Line Break","Number from Text"],"not_rendered":{"charts":0,"images":0,"macros":0,"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","index":0,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Dataset"]
[]
[null,"Name & Address"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]

{"sheet":"Column Wizard","index":1,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,2,3,4],[1,1,1,4]]}
[]
[null,"Use of Column Wizard"]
[]
[null,"Name & Address","Splitted Text"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]

{"sheet":"Flash Fill","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Flash Fill"]
[]
[null,"Name & Address",null,"Splitted Text"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]

{"sheet":"Combined Functions","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[3,2,3,3],[1,1,1,3]]}
[]
[null,"Combining  LEFT, RIGHT, FIND & LEN Functions"]
[]
[null,"Name & Address","Splitted Text"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null," "]

{"sheet":"TRANSPOSE","index":4,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[[3,2,3,4],[1,1,1,4]]}
[]
[null,"Inserting TRANSPOSE Function"]
[]
[null,"Name & Address","Splitted Text"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null," "]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[3,2,3,4],[1,1,1,4]]}
[]
[null,"Applying Excel VBA"]
[]
[null,"Name & Address","Splitted Text"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]

{"sheet":"Power Query","index":6,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use of Power Query"]
[]
[null,"Name & Address"]
[null,"Booth ,Portugal,44273"]
[null,"Melisse,Poland,33-240"]
[null,"Gillian,Spain,39080"]
[null,"Malinda,Russia,301170"]
[null,"Creed,Ecuador,44-020"]

{"sheet":"TEXTBEFORE & TEXTAFTER","index":7,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Applying TEXTBEFORE & TEXTAFTER Functions"]
[]
[null,"Full Name","First Name","Last Name","Middle Name"]
[null,"Robert De Niro"]
[null,"John Christopher Depp"]
[null,"Robert Downey Jr."]
[null,"Mel Columcille Gerard"]
[null,"Catherine Zeta Jones"]

{"sheet":"Line Break","index":8,"n_rows":7,"n_cols":3,"rows_kept":7,"cut":false,"hidden":false,"merged":[[3,2,3,4],[1,1,1,4]]}
[]
[null,"Spliting Text from a Line Break"]
[]
[null,"Name & Address","Splitted Text"]
[null,"Booth McMylor\n234 Coleman Plaza\nPortugal 44273"]
[null,"Melisse Barabisch\n391 Dahle Circle\nPoland 33-240"]
[null,"Gillian Flindall\n47 Westend Junction\nSantander Spain 39080"]

{"sheet":"Number from Text","index":9,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Splitting Numbers from Text"]
[]
[null,"Name & Address","Splitted Text"]
[null,"Booth McMylor,234 Coleman Plaza,Portugal"]
[null,"Melisse Barabisch,391 Dahle Circle,Poland"]
[null,"Gillian Flindall,47 Westend Junction,Spain"]
[null,"Malinda Thompson,3 Cruise Crossing,Russia"]
[null,"Creed William,38 Melvin Street,Ecuador"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null," "]