{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Custom Formula","Power Query","Practice"],"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":"Custom Formula","index":0,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Formula to Split Inconsistent Address"]
[]
[null,"Address","City","State","Zip Code"]
[null,"ALBANY NY 12205",{"$f":"LEFT(B5,LEN(B5)-(FIND(\" \",REV(B5),1)+3))","v":"ALBANY"},{"$f":"MID(B5,LEN(B5)-(FIND(\" \",REV(B5),1)+1),2)","v":"NY"},{"$f":"RIGHT(B5,FIND(\" \",REV(B5),1))","v":" 12205"}]
[null,"TOWSON MD 21204",{"$f":"LEFT(B6,LEN(B6)-(FIND(\" \",REV(B6),1)+3))","v":"TOWSON"},{"$f":"MID(B6,LEN(B6)-(FIND(\" \",REV(B6),1)+1),2)","v":"MD"},{"$f":"RIGHT(B6,FIND(\" \",REV(B6),1))","v":" 21204"}]
[null,"NEWBURGH,NY 12550","NEWBURGH",{"$f":"MID(B7,LEN(B7)-(FIND(\" \",REV(B7),1)+1),2)","v":"NY"},{"$f":"RIGHT(B7,FIND(\" \",REV(B7),1))","v":" 12550"}]
[null,"FT LAUDERDALE FL 33301","FT LAUDERDALE",{"$f":"MID(B8,LEN(B8)-(FIND(\" \",REV(B8),1)+1),2)","v":"FL"},{"$f":"RIGHT(B8,FIND(\" \",REV(B8),1))","v":" 33301"}]
[null,"EAST SYRACUSE NY 13057","EAST SYRACUSE",{"$f":"MID(B9,LEN(B9)-(FIND(\" \",REV(B9),1)+1),2)","v":"NY"},{"$f":"RIGHT(B9,FIND(\" \",REV(B9),1))","v":" 13057"}]
[null,"LIVERPOOL NY 13088","LIVERPOOL",{"$f":"MID(B10,LEN(B10)-(FIND(\" \",REV(B10),1)+1),2)","v":"NY"},{"$f":"RIGHT(B10,FIND(\" \",REV(B10),1))","v":" 13088"}]
[null,"BENNINGTON VT 05201-1606","BENNINGTON",{"$f":"MID(B11,LEN(B11)-(FIND(\" \",REV(B11),1)+1),2)","v":"VT"},{"$f":"RIGHT(B11,FIND(\" \",REV(B11),1))","v":" 05201-1606"}]
[null,"ITHACA NY 14850","ITHACA",{"$f":"MID(B12,LEN(B12)-(FIND(\" \",REV(B12),1)+1),2)","v":"NY"},{"$f":"RIGHT(B12,FIND(\" \",REV(B12),1))","v":" 14850"}]
[null,"DANBURY CT 06810","DANBURY",{"$f":"MID(B13,LEN(B13)-(FIND(\" \",REV(B13),1)+1),2)","v":"CT"},{"$f":"RIGHT(B13,FIND(\" \",REV(B13),1))","v":" 06810"}]
[null,"ROCHESTER NY 14611","ROCHESTER",{"$f":"MID(B14,LEN(B14)-(FIND(\" \",REV(B14),1)+1),2)","v":"NY"},{"$f":"RIGHT(B14,FIND(\" \",REV(B14),1))","v":" 14611"}]
[null,"ARAB AL 35016-0441","ARAB",{"$f":"MID(B15,LEN(B15)-(FIND(\" \",REV(B15),1)+1),2)","v":"AL"},{"$f":"RIGHT(B15,FIND(\" \",REV(B15),1))","v":" 35016-0441"}]
[null,"SYRACUSE NY 13211","SYRACUSE",{"$f":"MID(B16,LEN(B16)-(FIND(\" \",REV(B16),1)+1),2)","v":"NY"},{"$f":"RIGHT(B16,FIND(\" \",REV(B16),1))","v":" 13211"}]

{"sheet":"Power Query","index":1,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Power Query to Split Inconsistent Address"]
[]
[null,"Address","City","State","Zip Code"]
[null,"ALBANY NY 12205","ALBANY","NY","12205"]
[null,"TOWSON MD 21204","TOWSON","MD","21204"]
[null,"NEWBURGH,NY 12550","NEWBURGH","NY","12550"]
[null,"FT LAUDERDALE FL 33301","FT LAUDERDALE","FL","33301"]
[null,"EAST SYRACUSE NY 13057","EAST SYRACUSE","NY","13057"]
[null,"LIVERPOOL NY 13088","LIVERPOOL","NY","13088"]
[null,"BENNINGTON VT 05201-1606","BENNINGTON","VT","05201-1606"]
[null,"ITHACA NY 14850","ITHACA","NY","14850"]
[null,"DANBURY CT 06810","DANBURY","CT","06810"]
[null,"ROCHESTER NY 14611","ROCHESTER","NY","14611"]
[null,"ARAB AL 35016-0441","ARAB","AL","35016-0441"]
[null,"SYRACUSE NY 13211","SYRACUSE","NY","13211"]

{"sheet":"Practice","index":2,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Practice Here!!!"]
[]
[null,"Address"]
[null,"2701 NW 64TH TER MARGATE FL 33063-1703"]
[null,"901 NE 8 ST HALLANDALE BEACH FL 33009-2626"]
[null,"1840 DEWEY ST UNIT 305 HOLLYWOOD FL 33020"]
[null,"3049 NE 4 AVE WILTON MANORS FL 33334-2047"]
[null,"650 NE 56 CT OAKLAND PARK FL 33334-3528"]