{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Text to Column","Flash Fill","Text Function","Trim & MID Function","Power Query_2","Power Query_1","VBA Macro"],"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":"Text to Column","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Data in Excel"]
[]
[null,"Full Name","First Name","Last Name"]
[null,"Smith Joe","Smith","Joe"]
[null,"Lee Debble","Lee","Debble"]
[null,"thomas Frank","thomas","Frank"]
[null,"Carson Amos","Carson","Amos"]
[null,"Simpson Lisa","Simpson","Lisa"]
[null,"Robinson Phill","Robinson","Phill"]
[null,"Anderson Melissa","Anderson","Melissa"]

{"sheet":"Flash Fill","index":1,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Data in Excel"]
[]
[null,"Full Name","First Name","Last Name"]
[null,"Smith joe","Smith","joe"]
[null,"Lee Debble","Lee","Debble"]
[null,"thomas Frank","thomas","Frank"]
[null,"Carson Amos","Carson","Amos"]
[null,"Simpson Lisa","Simpson","Lisa"]
[null,"Robinson Phill","Robinson","Phill"]
[null,"Anderson Melissa","Anderson","Melissa"]

{"sheet":"Text Function","index":2,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Split Data in Excel"]
[]
[null,"Full Name","First Name","Middle Name","Last Name"]
[null,"Ronnie d. Anderson",{"$f":"LEFT(B5,SEARCH(\" \", B5)-1)","v":"Ronnie"},{"$f":"MID(B5,SEARCH(\" \",B5)+1,SEARCH(\" \",B5,SEARCH(\" \",B5)+1)-SEARCH(\" \",B5)-1)","v":"d."},{"$f":"RIGHT(B5,LEN(B5) - SEARCH(\" \", B5, SEARCH(\" \", B5,1)+1))","v":"Anderson"}]
[null,"John andrew Brown",{"$f":"LEFT(B6,SEARCH(\" \", B6)-1)","v":"John"},{"$f":"MID(B6,SEARCH(\" \",B6)+1,SEARCH(\" \",B6,SEARCH(\" \",B6)+1)-SEARCH(\" \",B6)-1)","v":"andrew"},{"$f":"RIGHT(B6,LEN(B6) - SEARCH(\" \", B6, SEARCH(\" \", B6,1)+1))","v":"Brown"}]
[null,"Ann claire brook ","Ann","claire","brook "]
[null,"Frank finn hill","Frank","finn","hill"]
[null,"Robert m. Fyrlan","Robert","m.","Fyrlan"]
[null,"Betty grace johnson","Betty","grace","johnson"]

{"sheet":"Trim & MID Function","index":3,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Split Data in Excel"]
[]
[null,"Full Name","First Name","Middle Name","Last Name"]
[null,"Ronnie d. Anderson",{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",999)),COLUMNS($C:C)*999-998,999))","v":"Ronnie"}]
[null,"John andrew Brown"]
[null,"Ann claire brook "]
[null,"Frank finn hill"]
[null,"Robert m. Fyrlan"]
[null,"Betty grace johnson"]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,{"$f":"TRIM(MID(SUBSTITUTE($B5,\" \",REPT(\" \",999)),COLUMNS($C:C)*999-998,999))","v":"Ronnie"}]

{"sheet":"Power Query_2","index":4,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Full Name","First Name","Middle Name","Last Name"]
["Ronnie d. Anderson","Ronnie","d.","Anderson"]
["John andrew Brown","John","andrew","Brown"]
["Ann claire brook ","Ann","claire","brook"]
["Frank finn hill","Frank","finn","hill"]
["Robert m. Fyrlan","Robert","m.","Fyrlan"]
["Betty grace johnson","Betty","grace","johnson"]

{"sheet":"Power Query_1","index":5,"n_rows":10,"n_cols":5,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Split Data in Excel"]
[]
[null,"Full Name","First Name","Middle Name","Last Name"]
[null,"Ronnie d. Anderson"]
[null,"John andrew Brown"]
[null,"Ann claire brook "]
[null,"Frank finn hill"]
[null,"Robert m. Fyrlan"]
[null,"Betty grace johnson"]

{"sheet":"VBA Macro","index":6,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Data in Excel"]
[]
[null,"Full Name","First Name","Last Name"]
[null,"Smith joe","Smith","joe"]
[null,"Lee Debble","Lee","Debble"]
[null,"thomas Frank","thomas","Frank"]
[null,"Carson Amos","Carson","Amos"]
[null,"Simpson Lisa","Simpson","Lisa"]
[null,"Robinson Phill","Robinson","Phill"]
[null,"Anderson Melissa","Anderson","Melissa"]