{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Text to Columns","VBA","Power Query Result","Power Query","Functions","Flash Fill"],"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":"Dataset","index":0,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Customer Register"]
[]
[null,"Customer ID","Customer Name and Other Infos"]
[null,"TX-001","Smith Martin Synth-Point-Music 47-Aspen-Avenue Gibsonia PA 15044"]
[null,"TX-002","Thoms Adrienne Sound-Mordern 494-Columbia-Avenue Salem MA 1970"]
[null,"TX-003","Magil Lena Cyberphonoc-Music 221-Dogwood-Avenue Corpus-Christi TX 78418"]
[null,"TX-004","Nelson Nick Electronic-Core 30-Sheffield-Court Chandler AX 85224"]
[null,"TX-005","Hope Jay Car-Solution 846-Wild-House-Dr Goose-Creak SC 29445"]
[null,"TX-006","Ray John Studiotronic 9175-Glendale-Avenue Hastings MN 55033"]
[null,"TX-007","Richardson Jeff New-Wave-Roar 32-Fermont-Street Troy NY 12180"]

{"sheet":"Text to Columns","index":1,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Using Text to Columns Feature"]
[]
[null,"Customer ID","First Name","Last Name","Company Name","Road Name","City","State","Zip Code"]
[null,"TX-001","Smith","Martin","Synth-Point-Music","47-Aspen-Avenue","Gibsonia","PA",15044]
[null,"TX-002","Thoms","Adrienne","Sound-Mordern","494-Columbia-Avenue","Salem","MA",1970]
[null,"TX-003","Magil","Lena","Cyberphonoc-Music","221-Dogwood-Avenue","Corpus-Christi","TX",78418]
[null,"TX-004","Nelson ","Nick","Electronic-Core","30-Sheffield-Court","Chandler","AX",85224]
[null,"TX-005","Hope","Jay","Car-Solution","846-Wild-House-Dr","Goose-Creak","SC",29445]
[null,"TX-006","Ray","John","Studiotronic","9175-Glendale-Avenue","Hastings","MN",55033]
[null,"TX-007","Richardson","Jeff","New-Wave-Roar","32-Fermont-Street","Troy","NY",12180]

{"sheet":"VBA","index":2,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,8]]}
[]
[null,"Using VBA Macro"]
[]
[null,"Customer ID","First Name","Last Name","Company Name","Road Name","City","State","Zip Code"]
[null,"TX-001","Smith","Martin","Synth-Point-Music","47-Aspen-Avenue","Gibsonia","PA","15044"]
[null,"TX-002","Thoms","Adrienne","Sound-Mordern","494-Columbia-Avenue","Salem","MA","1970"]
[null,"TX-003","Magil","Lena","Cyberphonoc-Music","221-Dogwood-Avenue","Corpus-Christi","TX","78418"]
[null,"TX-004","Nelson","Nick","Electronic-Core","30-Sheffield-Court","Chandler","AX","85224"]
[null,"TX-005","Hope","Jay","Car-Solution","846-Wild-House-Dr","Goose-Creak","SC","29445"]
[null,"TX-006","Ray","John","Studiotronic","9175-Glendale-Avenue","Hastings","MN","55033"]
[null,"TX-007","Richardson","Jeff","New-Wave-Roar","32-Fermont-Street","Troy","NY","12180"]

{"sheet":"Power Query Result","index":3,"n_rows":8,"n_cols":8,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Customer ID","First Name","Last Name","Company Name","Road Name","City","State","Zip Code"]
["TX-001","Smith","Martin","Synth-Point-Music","47-Aspen-Avenue","Gibsonia","PA",15044]
["TX-002","Thoms","Adrienne","Sound-Mordern","494-Columbia-Avenue","Salem","MA",1970]
["TX-003","Magil","Lena","Cyberphonoc-Music","221-Dogwood-Avenue","Corpus-Christi","TX",78418]
["TX-004","Nelson","Nick","Electronic-Core","30-Sheffield-Court","Chandler","AX",85224]
["TX-005","Hope","Jay","Car-Solution","846-Wild-House-Dr","Goose-Creak","SC",29445]
["TX-006","Ray","John","Studiotronic","9175-Glendale-Avenue","Hastings","MN",55033]
["TX-007","Richardson","Jeff","New-Wave-Roar","32-Fermont-Street","Troy","NY",12180]

{"sheet":"Power Query","index":4,"n_rows":11,"n_cols":3,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using Power uery"]
[]
[null,"Customer ID","Customer Name and Other Infos"]
[null,"TX-001","Smith Martin Synth-Point-Music 47-Aspen-Avenue Gibsonia PA 15044"]
[null,"TX-002","Thoms Adrienne Sound-Mordern 494-Columbia-Avenue Salem MA 1970"]
[null,"TX-003","Magil Lena Cyberphonoc-Music 221-Dogwood-Avenue Corpus-Christi TX 78418"]
[null,"TX-004","Nelson Nick Electronic-Core 30-Sheffield-Court Chandler AX 85224"]
[null,"TX-005","Hope Jay Car-Solution 846-Wild-House-Dr Goose-Creak SC 29445"]
[null,"TX-006","Ray John Studiotronic 9175-Glendale-Avenue Hastings MN 55033"]
[null,"TX-007","Richardson Jeff New-Wave-Roar 32-Fermont-Street Troy NY 12180"]

{"sheet":"Functions","index":5,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Functions"]
[]
[null,"Customer ID","Customer Name and Company Name","First Name","Last Name","Company Name"]
[null,"TX-001","Smith Martin Synth-Point-Music",{"$f":"LEFT(C5,SEARCH(\" \",C5)-1)","v":"Smith"},{"$f":"IFERROR(MID(C5,SEARCH(\" \",C5)+1,SEARCH(\" \",C5,SEARCH(\" \",C5)+1)-SEARCH(\" \",C5)),\"\")","v":"Martin "},{"$f":"IF(LEN(C5)-LEN(SUBSTITUTE(C5,\" \",\"\"))=1,RIGHT(C5,LEN(C5)-SEARCH(\" \",C5)),\nRIGHT(C5,LEN(C5)-SEARCH(\" \",C5,SEARCH(\" \",C5)+1)))","v":"Synth-Point-Music"}]
[null,"TX-002","Thoms Adrienne Sound-Mordern",{"$f":"LEFT(C6,SEARCH(\" \",C6)-1)","v":"Thoms"},{"$f":"IFERROR(MID(C6,SEARCH(\" \",C6)+1,SEARCH(\" \",C6,SEARCH(\" \",C6)+1)-SEARCH(\" \",C6)),\"\")","v":"Adrienne "},{"$f":"IF(LEN(C6)-LEN(SUBSTITUTE(C6,\" \",\"\"))=1,RIGHT(C6,LEN(C6)-SEARCH(\" \",C6)),\nRIGHT(C6,LEN(C6)-SEARCH(\" \",C6,SEARCH(\" \",C6)+1)))","v":"Sound-Mordern"}]
[null,"TX-003","Magil Lena Cyberphonoc-Music","Magil","Lena ","Cyberphonoc-Music"]
[null,"TX-004","Nelson Nick Electronic-Core","Nelson","Nick ","Electronic-Core"]
[null,"TX-005","Hope Jay Car-Solution","Hope","Jay ","Car-Solution"]
[null,"TX-006","Ray John Studiotronic","Ray","John ","Studiotronic"]
[null,"TX-007","Richardson Jeff New-Wave-Roar","Richardson","Jeff ","New-Wave-Roar"]

{"sheet":"Flash Fill","index":6,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Using Flash Fill"]
[]
[null,"Customer ID","Customer Name and Company Name","First Name","Last Name","Company Name"]
[null,"TX-001","Smith Martin Synth-Point-Music","Smith","Martin","Synth-Point-Music"]
[null,"TX-002","Thoms Adrienne Sound-Mordern","Thoms","Adrienne","Sound-Mordern"]
[null,"TX-003","Magil Lena Cyberphonoc-Music","Magil","Lena","Cyberphonoc-Music"]
[null,"TX-004","Nelson Nick Electronic-Core","Nelson","Nick","Electronic-Core"]
[null,"TX-005","Hope Jay Car-Solution","Hope","Jay","Car-Solution"]
[null,"TX-006","Ray John Studiotronic","Ray","John","Studiotronic"]
[null,"TX-007","Richardson Jeff New-Wave-Roar","Richardson","Jeff","New-Wave-Roar"]