{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Text to Columns","Flash Fill","Formula","Power Query","VBA"],"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":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Split Column in Excel by Word"]
[]
[null,"Address"]
[null,"20235 N CAVE CREEK RD SUITE A100"]
[null,"320 WEST 5TH AVE SUITE 182 - 1ST FLOOR"]
[null,"1830 E. PARKS HIGHWAY SUITE A 112"]
[null,"4711 BUSINESS PARK BLVD SUITE 10 BLDG 1"]
[null,"402 W. MARINE WAY SUITE 100-SHIPS BLDG"]

{"sheet":"Text to Columns","index":1,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Column in Excel by Word with Text to Columns Wizard"]
[]
[null,"Address","Address 1","Address 2"]
[null,"20235 N CAVE CREEK RD SUITE A100","20235 N CAVE CREEK RD ","SUITE A100"]
[null,"320 WEST 5TH AVE SUITE 182 - 1ST FLOOR","320 WEST 5TH AVE ","SUITE 182 - 1ST FLOOR"]
[null,"1830 E. PARKS HIGHWAY SUITE A 112","1830 E. PARKS HIGHWAY ","SUITE A 112"]
[null,"4711 BUSINESS PARK BLVD SUITE 10 BLDG 1","4711 BUSINESS PARK BLVD ","SUITE 10 BLDG 1"]
[null,"402 W. MARINE WAY SUITE 100-SHIPS BLDG","402 W. MARINE WAY ","SUITE 100-SHIPS BLDG"]

{"sheet":"Flash Fill","index":2,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Column in Excel by Word with Flash Fill"]
[]
[null,"Address","Address 1","Address 2"]
[null,"20235 N CAVE CREEK RD #SUITE A100","20235 N CAVE CREEK RD","SUITE A100"]
[null,"320 WEST 5TH AVE #SUITE 182 - 1ST FLOOR","320 WEST 5TH AVE","SUITE 182 - 1ST FLOOR"]
[null,"1830 E. PARKS HIGHWAY #SUITE A 112","1830 E. PARKS HIGHWAY","SUITE A 112"]
[null,"4711 BUSINESS PARK BLVD #SUITE 10 BLDG 1","4711 BUSINESS PARK BLVD","SUITE 10 BLDG 1"]
[null,"402 W. MARINE WAY #SUITE 100-SHIPS BLDG","402 W. MARINE WAY","SUITE 100-SHIPS BLDG"]

{"sheet":"Formula","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Column in Excel by Word with LEFT, RIGHT, LEN & SEARCH Functions"]
[]
[null,"Address","Address 1","Address 2"]
[null,"20235 N CAVE CREEK RD SUITE A100",{"$f":"LEFT(B5,SEARCH(\"SUITE\",B5)-2)","v":"20235 N CAVE CREEK RD"},{"$f":"RIGHT(B5,LEN(B5)-SEARCH(\"SUITE\",B5)+1)","v":"SUITE A100"}]
[null,"320 WEST 5TH AVE SUITE 182 - 1ST FLOOR",{"$f":"LEFT(B6,SEARCH(\"SUITE\",B6)-2)","v":"320 WEST 5TH AVE"},{"$f":"RIGHT(B6,LEN(B6)-SEARCH(\"SUITE\",B6)+1)","v":"SUITE 182 - 1ST FLOOR"}]
[null,"1830 E. PARKS HIGHWAY SUITE A 112","1830 E. PARKS HIGHWAY","SUITE A 112"]
[null,"4711 BUSINESS PARK BLVD SUITE 10 BLDG 1","4711 BUSINESS PARK BLVD","SUITE 10 BLDG 1"]
[null,"402 W. MARINE WAY SUITE 100-SHIPS BLDG","402 W. MARINE WAY","SUITE 100-SHIPS BLDG"]

{"sheet":"Power Query","index":4,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Column in Excel by Word with Power Query"]
[]
[null,"Address","Address.1","Address.2"]
[null,"20235 N CAVE CREEK RD SUITE A100","20235 N CAVE CREEK RD ","SUITE A100"]
[null,"320 WEST 5TH AVE SUITE 182 - 1ST FLOOR","320 WEST 5TH AVE ","SUITE 182 - 1ST FLOOR"]
[null,"1830 E. PARKS HIGHWAY SUITE A 112","1830 E. PARKS HIGHWAY ","SUITE A 112"]
[null,"4711 BUSINESS PARK BLVD SUITE 10 BLDG 1","4711 BUSINESS PARK BLVD ","SUITE 10 BLDG 1"]
[null,"402 W. MARINE WAY SUITE 100-SHIPS BLDG","402 W. MARINE WAY ","SUITE 100-SHIPS BLDG"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Split Column by Word with Excel VBA"]
[]
[null,"Address","Address 1","Address 2"]
[null,"20235 N CAVE CREEK RD SUITE A100","20235 N CAVE CREEK RD ","SUITE A100"]
[null,"320 WEST 5TH AVE SUITE 182 - 1ST FLOOR","320 WEST 5TH AVE ","SUITE 182 - 1ST FLOOR"]
[null,"1830 E. PARKS HIGHWAY SUITE A 112","1830 E. PARKS HIGHWAY ","SUITE A 112"]
[null,"4711 BUSINESS PARK BLVD SUITE 10 BLDG 1","4711 BUSINESS PARK BLVD ","SUITE 10 BLDG 1"]
[null,"402 W. MARINE WAY SUITE 100-SHIPS BLDG","402 W. MARINE WAY ","SUITE 100-SHIPS BLDG"]