{"text_format":"1","workbook":"xlsx","n_sheets":15,"sheets":["Special Custom Formatting","Manual Custom Formatting","Custom Formatting to 5 Digits","TEXT","LEFT","VBA","Include Leading Characters","Text Zip Codes","Sort Ascending","Sort Descending","Sort by States","Filters","5 and 9 Digits","Remove Last 4 Digits","Overview Image"],"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":"Special Custom Formatting","index":0,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Special Formatting",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Number","Zip Code",null,null,null,null,"Address","Number","Zip Code"]
[null,"123 Main Street, Anytown, USA",12345,12345,null,null,null,null,"123 Main Street, Anytown, USA",12345]
[null,"456 Elm Avenue, Springfield, USA",67890,67890,null,null,null,null,"456 Elm Avenue, Springfield, USA",67890]
[null,"789 Oak Lane, Lakeside, USA",23456,23456,null,null,null,null,"789 Oak Lane, Lakeside, USA",23456]
[null,"321 Pine Street, Mountainville, USA",34567,34567,null,null,null,null,"321 Pine Street, Mountainville, USA",34567]
[null,"987 Maple Drive, Riverside, USA",45678,45678,null,null,null,null,"987 Maple Drive, Riverside, USA",45678]
[null,"555 Willow Lane, Lexington, USA",9262,9262,null,null,null,null,"555 Willow Lane, Lexington, USA",9262]
[null,"987 Elm Court, Lakeside, USA",9171,9171,null,null,null,null,"987 Elm Court, Lakeside, USA",9171]

{"sheet":"Manual Custom Formatting","index":1,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Custom Formatting",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Number","Zip Code",null,null,null,null,"Address","Number","Zip Code"]
[null,"123 Main Street, Anytown, USA",12345,12345,null,null,null,null,"123 Main Street, Anytown, USA",12345]
[null,"456 Elm Avenue, Springfield, USA",67890,67890,null,null,null,null,"456 Elm Avenue, Springfield, USA",67890]
[null,"789 Oak Lane, Lakeside, USA",23456,23456,null,null,null,null,"789 Oak Lane, Lakeside, USA",23456]
[null,"321 Pine Street, Mountainville, USA",34567,34567,null,null,null,null,"321 Pine Street, Mountainville, USA",34567]
[null,"987 Maple Drive, Riverside, USA",45678,45678,null,null,null,null,"987 Maple Drive, Riverside, USA",45678]
[null,"555 Willow Lane, Lexington, USA",9262,9262,null,null,null,null,"555 Willow Lane, Lexington, USA",9262]
[null,"987 Elm Court, Lakeside, USA",9171,9171,null,null,null,null,"987 Elm Court, Lakeside, USA",9171]

{"sheet":"Custom Formatting to 5 Digits","index":2,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Custom Formatting",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Number","Zip Code",null,null,null,null,"Address","Number","Zip Code"]
[null,"123 Main Street, Anytown, USA",12345,12345,null,null,null,null,"123 Main Street, Anytown, USA",12345]
[null,"456 Elm Avenue, Springfield, USA",67890,67890,null,null,null,null,"456 Elm Avenue, Springfield, USA",67890]
[null,"789 Oak Lane, Lakeside, USA",23456,23456,null,null,null,null,"789 Oak Lane, Lakeside, USA",23456]
[null,"321 Pine Street, Mountainville, USA",34567,34567,null,null,null,null,"321 Pine Street, Mountainville, USA",34567]
[null,"987 Maple Drive, Riverside, USA",45678,45678,null,null,null,null,"987 Maple Drive, Riverside, USA",45678]
[null,"555 Willow Lane, Lexington, USA",9262,9262,null,null,null,null,"555 Willow Lane, Lexington, USA",9262]
[null,"987 Elm Court, Lakeside, USA",9171,9171,null,null,null,null,"987 Elm Court, Lakeside, USA",9171]

{"sheet":"TEXT","index":3,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code","Result",null,null,null,null,"Address","Zip Code","Result"]
[null,"123 Main Street, Anytown, USA",9705,{"$f":"TEXT(C5,\"00000\")","v":"09705"},null,null,null,null,"123 Main Street, Anytown, USA",9705]
[null,"456 Elm Avenue, Springfield, USA",9956,{"$f":"TEXT(C6,\"00000\")","v":"09956"},null,null,null,null,"456 Elm Avenue, Springfield, USA",9956]
[null,"789 Oak Lane, Lakeside, USA",852,"00852",null,null,null,null,"789 Oak Lane, Lakeside, USA",852]
[null,"321 Pine Street, Mountainville, USA",9250,"09250",null,null,null,null,"321 Pine Street, Mountainville, USA",9250]
[null,"987 Maple Drive, Riverside, USA",8520,"08520",null,null,null,null,"987 Maple Drive, Riverside, USA",8520]
[null,"555 Willow Lane, Lexington, USA",926,"00926",null,null,null,null,"555 Willow Lane, Lexington, USA",926]
[null,"987 Elm Court, Lakeside, USA",9171,"09171",null,null,null,null,"987 Elm Court, Lakeside, USA",9171]

{"sheet":"LEFT","index":4,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of LEFT Function",null,null,null,null,null,null,null,"Use of LEFT Function"]
[]
[null,"Address","Zip Code","Result",null,null,null,null,null,"Address","Zip Code","Result"]
[null,"123 Main Street, Anytown, USA","20619-2001",{"$f":"LEFT(C5,5)","v":"20619"},null,null,null,null,null,"123 Main Street, Anytown, USA","20619-2001"]
[null,"456 Elm Avenue, Springfield, USA","90007-0121","90007",null,null,null,null,null,"456 Elm Avenue, Springfield, USA","90007-0121"]
[null,"789 Oak Lane, Lakeside, USA","90210-2003","90210",null,null,null,null,null,"789 Oak Lane, Lakeside, USA","90210-2003"]
[null,"321 Pine Street, Mountainville, USA","90007-0831","90007",null,null,null,null,null,"321 Pine Street, Mountainville, USA","90007-0831"]
[null,"987 Maple Drive, Riverside, USA","20619-2005","20619",null,null,null,null,null,"987 Maple Drive, Riverside, USA","20619-2005"]
[null,"555 Willow Lane, Lexington, USA","20619-2006","20619",null,null,null,null,null,"555 Willow Lane, Lexington, USA","20619-2006"]
[null,"987 Elm Court, Lakeside, USA","92024-2852","92024",null,null,null,null,null,"987 Elm Court, Lakeside, USA","92024-2852"]

{"sheet":"VBA","index":5,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of VBA",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code","5 Digit",null,null,null,null,null,"Address","Zip Code","5 Digit"]
[null,"123 Main Street, Anytown","12345-0001",12345,null,null,null,null,null,"123 Main Street, Anytown","12345-0001"]
[null,"456 Elm Avenue, Springfield","67890-0002",67890,null,null,null,null,null,"456 Elm Avenue, Springfield","67890-0002"]
[null,"789 Oak Lane, Lakeside","23456-0003",23456,null,null,null,null,null,"789 Oak Lane, Lakeside","23456-0003"]
[null,"321 Pine Street, Mountainville","34567-0004",34567,null,null,null,null,null,"321 Pine Street, Mountainville","34567-0004"]
[null,"987 Maple Drive, Riverside","45678-0005",45678,null,null,null,null,null,"987 Maple Drive, Riverside","45678-0005"]
[null,"555 Willow Lane, Lexington","19262-0006",19262,null,null,null,null,null,"555 Willow Lane, Lexington","19262-0006"]
[null,"987 Elm Court, Lakeside","29171-0007",29171,null,null,null,null,null,"987 Elm Court, Lakeside","29171-0007"]

{"sheet":"Include Leading Characters","index":6,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Leading Characters in Zip Code",null,null,null,null,null,null,"Leading Characters in Zip Code"]
[]
[null,"Address","Zip Code","Result",null,null,null,null,"Address","Zip Code","Result"]
[null,"123 Main Street, Anytown, USA",9705,{"$f":"TEXT(C5,\"00000\")","v":"09705"},null,null,null,null,"123 Main Street, Anytown, USA",9705]
[null,"456 Elm Avenue, Springfield, USA",9956,{"$f":"TEXT(C6,\"00000\")","v":"09956"},null,null,null,null,"456 Elm Avenue, Springfield, USA",9956]
[null,"789 Oak Lane, Lakeside, USA",852,"00852",null,null,null,null,"789 Oak Lane, Lakeside, USA",852]
[null,"321 Pine Street, Mountainville, USA",9250,"09250",null,null,null,null,"321 Pine Street, Mountainville, USA",9250]
[null,"987 Maple Drive, Riverside, USA",8520,"08520",null,null,null,null,"987 Maple Drive, Riverside, USA",8520]
[null,"555 Willow Lane, Lexington, USA",926,"00926",null,null,null,null,"555 Willow Lane, Lexington, USA",926]
[null,"987 Elm Court, Lakeside, USA",9171,"09171",null,null,null,null,"987 Elm Court, Lakeside, USA",9171]

{"sheet":"Text Zip Codes","index":7,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Text in Zip Codes"]
[]
[null,"Address","Zip Code"]
[null,"Buckingham Palace, London","SW1A 0AA"]
[null,"Edinburgh Castle, Edinburgh","EH1 1QB"]
[null,"Manchester Central, Manchester","M1 1AA"]
[null,"Bristol City Centre, Bristol","BS1 1AA"]
[null,"City Centre, Belfast","BT1 1AA"]

{"sheet":"Sort Ascending","index":8,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Sort in Ascending Order ",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,null,null,"Address","Zip Code"]
[null,"789 Oak Lane, Lakeside, USA",85200,null,null,null,null,null,null,"789 Oak Lane, Lakeside, USA",85200]
[null,"987 Maple Drive, Riverside, USA",85202,null,null,null,null,null,null,"987 Maple Drive, Riverside, USA",85202]
[null,"987 Elm Court, Lakeside, USA",91718,null,null,null,null,null,null,"987 Elm Court, Lakeside, USA",91718]
[null,"321 Pine Street, Mountainville, USA",92501,null,null,null,null,null,null,"321 Pine Street, Mountainville, USA",92501]
[null,"555 Willow Lane, Lexington, USA",92621,null,null,null,null,null,null,"555 Willow Lane, Lexington, USA",92621]
[null,"123 Main Street, Anytown, USA",97051,null,null,null,null,null,null,"123 Main Street, Anytown, USA",97051]
[null,"456 Elm Avenue, Springfield, USA",99563,null,null,null,null,null,null,"456 Elm Avenue, Springfield, USA",99563]

{"sheet":"Sort Descending","index":9,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Sort in Descending Order ",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,null,null,"Address","Zip Code"]
[null,"456 Elm Avenue, Springfield, USA",99563,null,null,null,null,null,null,"789 Oak Lane, Lakeside, USA",85200]
[null,"123 Main Street, Anytown, USA",97051,null,null,null,null,null,null,"987 Maple Drive, Riverside, USA",85202]
[null,"555 Willow Lane, Lexington, USA",92621,null,null,null,null,null,null,"987 Elm Court, Lakeside, USA",91718]
[null,"321 Pine Street, Mountainville, USA",92501,null,null,null,null,null,null,"321 Pine Street, Mountainville, USA",92501]
[null,"987 Elm Court, Lakeside, USA",91718,null,null,null,null,null,null,"555 Willow Lane, Lexington, USA",92621]
[null,"987 Maple Drive, Riverside, USA",85202,null,null,null,null,null,null,"123 Main Street, Anytown, USA",97051]
[null,"789 Oak Lane, Lakeside, USA",85200,null,null,null,null,null,null,"456 Elm Avenue, Springfield, USA",99563]

{"sheet":"Sort by States","index":10,"n_rows":12,"n_cols":10,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2],[2,8,2,9]]}
[]
[null,"Sort by States"]
[null,null,null,null,null,null,null,null,"Do Yourself"]
[null,"State","Zip Codes"]
[null,"California","90001, 90210, 94102, 95616, 96002",null,null,null,null,null,"State","Zip Codes"]
[null,"New York","10001, 10453, 11201, 12345, 14623",null,null,null,null,null,"California","90001, 90210, 94102, 95616, 96002"]
[null,"Texas","75001, 77002, 78701, 79901, 88595",null,null,null,null,null,"New York","10001, 10453, 11201, 12345, 14623"]
[null,"Florida","32003, 33101, 33602, 34102, 34994",null,null,null,null,null,"Texas","75001, 77002, 78701, 79901, 88595"]
[null,"Illinois","60007, 60601, 61201, 62701, 62901",null,null,null,null,null,"Florida","32003, 33101, 33602, 34102, 34994"]
[null,"Pennsylvania","15001, 16501, 17001, 19001, 19406",null,null,null,null,null,"Illinois","60007, 60601, 61201, 62701, 62901"]
[null,"Ohio","43001, 43201, 44001, 45201, 45801",null,null,null,null,null,"Pennsylvania","15001, 16501, 17001, 19001, 19406"]
[null,null,null,null,null,null,null,null,"Ohio","43001, 43201, 44001, 45201, 45801"]

{"sheet":"Filters","index":11,"n_rows":11,"n_cols":11,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Filters to Sort Zip Codes",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code",null,null,null,null,null,null,"Address","Zip Code"]
[null,"123 Main Street, Anytown, USA",97051,null,null,null,null,null,null,"123 Main Street, Anytown, USA",97051]
[null,"456 Elm Avenue, Springfield, USA",99563,null,null,null,null,null,null,"456 Elm Avenue, Springfield, USA",99563]
[null,"789 Oak Lane, Lakeside, USA",85200,null,null,null,null,null,null,"789 Oak Lane, Lakeside, USA",85200]
[null,"321 Pine Street, Mountainville, USA",92501,null,null,null,null,null,null,"321 Pine Street, Mountainville, USA",92501]
[null,"987 Maple Drive, Riverside, USA",85202,null,null,null,null,null,null,"987 Maple Drive, Riverside, USA",85202]
[null,"555 Willow Lane, Lexington, USA",92621,null,null,null,null,null,null,"555 Willow Lane, Lexington, USA",92621]
[null,"987 Elm Court, Lakeside, USA",91718,null,null,null,null,null,null,"987 Elm Court, Lakeside, USA",91718]

{"sheet":"5 and 9 Digits","index":12,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"5 and 9 Digit Zip Code",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code","Correct Format",null,null,null,null,null,"Address","Zip Code","Correct Format"]
[null,"123 Main Street, Anytown, USA",206192001,{"$f":"C5","v":206192001},null,null,null,null,null,"123 Main Street, Anytown, USA",206192001]
[null,"456 Elm Avenue, Springfield, USA",900070121,900070121,null,null,null,null,null,"456 Elm Avenue, Springfield, USA",900070121]
[null,"789 Oak Lane, Lakeside, USA",902102003,902102003,null,null,null,null,null,"789 Oak Lane, Lakeside, USA",902102003]
[null,"321 Pine Street, Mountainville, USA",900070831,900070831,null,null,null,null,null,"321 Pine Street, Mountainville, USA",900070831]
[null,"987 Maple Drive, Riverside, USA",45678,45678,null,null,null,null,null,"987 Maple Drive, Riverside, USA",45678]
[null,"555 Willow Lane, Lexington, USA",9262,9262,null,null,null,null,null,"555 Willow Lane, Lexington, USA",9262]
[null,"987 Elm Court, Lakeside, USA",9171,9171,null,null,null,null,null,"987 Elm Court, Lakeside, USA",9171]

{"sheet":"Remove Last 4 Digits","index":13,"n_rows":11,"n_cols":12,"rows_kept":11,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Remove Last 4 Digits",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"Address","Zip Code","5 Digit Zip Code",null,null,null,null,null,"Address","Zip Code","5 Digit Zip Code"]
[null,"123 Main Street, Anytown, USA","20619-2001",{"$f":"MID(C5,1,5)","v":"20619"},null,null,null,null,null,"123 Main Street, Anytown, USA","20619-2001",{"$f":"MID(K5,1,5)","v":"20619"}]
[null,"456 Elm Avenue, Springfield, USA","90007-0121",{"$f":"MID(C6,1,5)","v":"90007"},null,null,null,null,null,"456 Elm Avenue, Springfield, USA","90007-0121",{"$f":"MID(K6,1,5)","v":"90007"}]
[null,"789 Oak Lane, Lakeside, USA","90210-2003","90210",null,null,null,null,null,"789 Oak Lane, Lakeside, USA","90210-2003","90210"]
[null,"321 Pine Street, Mountainville, USA","90007-0831","90007",null,null,null,null,null,"321 Pine Street, Mountainville, USA","90007-0831","90007"]
[null,"987 Maple Drive, Riverside, USA","20619-2005","20619",null,null,null,null,null,"987 Maple Drive, Riverside, USA","20619-2005","20619"]
[null,"555 Willow Lane, Lexington, USA","20619-2006","20619",null,null,null,null,null,"555 Willow Lane, Lexington, USA","20619-2006","20619"]
[null,"987 Elm Court, Lakeside, USA","92024-2852","92024",null,null,null,null,null,"987 Elm Court, Lakeside, USA","92024-2852","92024"]

{"sheet":"Overview Image","index":14,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":true,"merged":[[10,1,10,5],[3,1,3,5],[1,1,1,5]]}
[]
[null,"Overview of Zip Code in Excel"]
[]
[null,"9 Digit Zip Code"]
[]
[null,"Address","Number","Special Format","Custom Format","Leading Zeros"]
[null,"123 Main Street, Anytown, USA",12345,12345,12345,12345]
[null,"456 Elm Avenue, Springfield, USA",67890,67890,67890,67890]
[null,"789 Oak Lane, Lakeside, USA",23456,23456,23456,23456]
[]
[null,"5 Digit Zip Code"]
[]
[null,"Address","Number","LEFT Function","MID Function","Remove Last 4 Digits"]
[null,"987 Maple Drive, Riverside, USA",206192001,{"$f":"LEFT(C14,5)","v":"20619"},{"$f":"MID(C14,1,5)","v":"20619"},{"$f":"MID(D14,1,5)","v":"20619"}]
[null,"555 Willow Lane, Lexington, USA",900070121,{"$f":"LEFT(C15,5)","v":"90007"},{"$f":"MID(C15,1,5)","v":"90007"},"90007"]
[null,"987 Elm Court, Lakeside, USA",902102003,"90210","90210","90210"]