{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Dataset","Text to Column ","LEFT RIGHT SEARCH","LEFT RIGHT LEN FIND","VBAMethod","Power Query","Sheet5","Flash Fill"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":1,"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":"Dataset","index":0,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name"]
[null,"Jane Doe"]
[null,"Rocky Montana"]
[null,"Tom Cruse"]
[null,"Brayan Taylor"]
[null,"Tom Jenkings"]
[null,"Jannet Leverling"]
[null,"Anne Buchman"]
[null,"Clint Burton"]
[null,"Sofi Turner"]
[null,"Maria Rossa"]

{"sheet":"Text to Column ","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name","First Name","Last Name "]
[null,"Jane Doe","Jane","Doe"]
[null,"Rocky Montana","Rocky","Montana"]
[null,"Tom Cruse","Tom","Cruse"]
[null,"Brayan Taylor","Brayan","Taylor"]
[null,"Tom Jenkings","Tom","Jenkings"]
[null,"Jannet Leverling","Jannet","Leverling"]
[null,"Anne Buchman","Anne","Buchman"]
[null,"Clint Burton","Clint","Burton"]
[null,"Sofi Turner","Sofi","Turner"]
[null,"Maria Rossa","Maria","Rossa"]

{"sheet":"LEFT RIGHT SEARCH","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name","First Name","Last Name"]
[null,"Jane Doe",{"$f":"LEFT(B3, SEARCH(\" \",B3,1))","v":"Jane "},{"$f":"RIGHT(B3,LEN(B3)-SEARCH(\" \",B3,SEARCH(\"\",B3)+1))","v":"Doe"}]
[null,"Rocky Montana",{"$f":"LEFT(B4, SEARCH(\" \",B4,1))","v":"Rocky "},{"$f":"RIGHT(B4,LEN(B4)-SEARCH(\" \",B4,SEARCH(\"\",B4)+1))","v":"Montana"}]
[null,"Tom Cruse","Tom ","Cruse"]
[null,"Brayan Taylor","Brayan ","Taylor"]
[null,"Tom Jenkings","Tom ","Jenkings"]
[null,"Jannet Leverling","Jannet ","Leverling"]
[null,"Anne Buchman","Anne ","Buchman"]
[null,"Clint Burton","Clint ","Burton"]
[null,"Sofi Turner","Sofi ","Turner"]
[null,"Maria Rossa","Maria ","Rossa"]

{"sheet":"LEFT RIGHT LEN FIND","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name","First Name","Last Name"]
[null,"Jane Doe",{"$f":"LEFT(B3,FIND(\" \",B3)-1)","v":"Jane"},{"$f":"RIGHT(B3,LEN(B3)-FIND(\" \",B3))","v":"Doe"}]
[null,"Rocky Montana",{"$f":"LEFT(B4,FIND(\" \",B4)-1)","v":"Rocky"},{"$f":"RIGHT(B4,LEN(B4)-FIND(\" \",B4))","v":"Montana"}]
[null,"Tom Cruse","Tom","Cruse"]
[null,"Brayan Taylor","Brayan","Taylor"]
[null,"Tom Jenkings","Tom","Jenkings"]
[null,"Jannet Leverling","Jannet","Leverling"]
[null,"Anne Buchman","Anne","Buchman"]
[null,"Clint Burton","Clint","Burton"]
[null,"Sofi Turner","Sofi","Turner"]
[null,"Maria Rossa","Maria","Rossa"]

{"sheet":"VBAMethod","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name","Full Name","Last Name"]
[null,"Jane,Doe","Jane","Doe"]
[null,"Rocky,Montana","Rocky","Montana"]
[null,"Tom,Cruse","Tom","Cruse"]
[null,"Brayan,Taylor","Brayan","Taylor"]
[null,"Tom,Jenkings","Tom","Jenkings"]
[null,"Jannet,Leverling","Jannet","Leverling"]
[null,"Anne,Buchman","Anne","Buchman"]
[null,"Clint,Burton","Clint","Burton"]
[null,"Sofi,Turner","Sofi","Turner"]
[null,"Maria,Rossa","Maria","Rossa"]

{"sheet":"Power Query","index":5,"n_rows":12,"n_cols":2,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name"]
[null,"Jane Doe"]
[null,"Rocky Montana"]
[null,"Tom Cruse"]
[null,"Brayan Taylor"]
[null,"Tom Jenkings"]
[null,"Jannet Leverling"]
[null,"Anne Buchman"]
[null,"Clint Burton"]
[null,"Sofi Turner"]
[null,"Maria Rossa"]

{"sheet":"Sheet5","index":6,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name.1","Full Name.2"]
[null,"Jane","Doe"]
[null,"Rocky","Montana"]
[null,"Tom","Cruse"]
[null,"Brayan","Taylor"]
[null,"Tom","Jenkings"]
[null,"Jannet","Leverling"]
[null,"Anne","Buchman"]
[null,"Clint","Burton"]
[null,"Sofi","Turner"]
[null,"Maria","Rossa"]

{"sheet":"Flash Fill","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Full Name","First Name","Last Name "]
[null,"Jane Doe","Jane","Doe"]
[null,"Rocky Montana","Rocky","Montana"]
[null,"Tom Cruse","Tom","Cruse"]
[null,"Brayan Taylor","Brayan","Taylor"]
[null,"Tom Jenkings","Tom","Jenkings"]
[null,"Jannet Leverling","Jannet","Leverling"]
[null,"Anne Buchman","Anne","Buchman"]
[null,"Clint Burton","Clint","Burton"]
[null,"Sofi Turner","Sofi","Turner"]
[null,"Maria Rossa","Maria","Rossa"]