{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["LEFT Function","MID Function","Text to Column","INT Function","INT & SUBSTITUE","TEXT & LEFT","VBA Code","SUM, LEN & SUBSTITUTE","LEFT, MIN & FIND","ISNUMBER, RIGHT, LEFT,LEN"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"LEFT Function","index":0,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Application of LEFT Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",{"$f":"LEFT(C5,5)","v":"20619"},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",{"$f":"LEFT(C6,5)","v":"90007"},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003","90210",null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831","90007",null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005","20619",null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006","20619",null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852","92024",null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007","20619",null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008","20619",null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000","90007",null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"MID Function","index":1,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Insertion of MID Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",{"$f":"MID(C5,1,5)","v":"20619"},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",{"$f":"MID(C6,1,5)","v":"90007"},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003","90210",null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831","90007",null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005","20619",null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006","20619",null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852","92024",null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007","20619",null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008","20619",null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000","90007",null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"Text to Column","index":2,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Use of Text to Column Feature",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",20619,null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",90007,null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003",90210,null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831",90007,null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005",20619,null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006",20619,null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852",92024,null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007",20619,null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008",20619,null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000",90007,null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"INT Function","index":3,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Application of INT Function",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR",206192001,{"$f":"INT(C5/10000)","v":20619},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA",900070121,{"$f":"INT(C6/10000)","v":90007},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA",902102003,90210,null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA",900070831,90007,null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200",206192005,20619,null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN",206192006,20619,null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA",920242852,92024,null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD",206192007,20619,null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY",206192008,20619,null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA",900071000,90007,null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"INT & SUBSTITUE","index":4,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combination of INT and SUBSTITUTE Functions",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",{"$f":"INT(SUBSTITUTE(C5,\"-\",\".\"))","v":20619},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",{"$f":"INT(SUBSTITUTE(C6,\"-\",\".\"))","v":90007},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003",90210,null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831",90007,null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005",20619,null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006",20619,null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852",92024,null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007",20619,null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008",20619,null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000",90007,null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"TEXT & LEFT","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combination of TEXT and LEFT Functions",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",{"$f":"LEFT(TEXT(C5,\"00000\"),5)","v":"20619"},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",{"$f":"LEFT(TEXT(C6,\"00000\"),5)","v":"90007"},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003","90210",null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831","90007",null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005","20619",null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006","20619",null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852","92024",null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007","20619",null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008","20619",null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000","90007",null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"VBA Code","index":6,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,9,1,11],[1,1,1,2]]}
[]
[null,"Running a VBA Code",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","ZIP Code",null,null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR",20619,null,null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA",90007,null,null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA",90210,null,null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA",90007,null,null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200",20619,null,null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN",20619,null,null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA",92024,null,null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD",20619,null,null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY",20619,null,null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA",90007,null,null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"SUM, LEN & SUBSTITUTE","index":7,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combination of SUM, LEN and SUBSTITUTE Functions",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",{"$f":"IF(SUM(LEN(C5)-LEN(SUBSTITUTE(C5,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C5,LEN(C5)-5),C5)","v":"20619"},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",{"$f":"IF(SUM(LEN(C6)-LEN(SUBSTITUTE(C6,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C6,LEN(C6)-5),C6)","v":"90007"},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003",{"$f":"IF(SUM(LEN(C7)-LEN(SUBSTITUTE(C7,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C7,LEN(C7)-5),C7)","v":"90210"},null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831",{"$f":"IF(SUM(LEN(C8)-LEN(SUBSTITUTE(C8,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C8,LEN(C8)-5),C8)","v":"90007"},null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005",{"$f":"IF(SUM(LEN(C9)-LEN(SUBSTITUTE(C9,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C9,LEN(C9)-5),C9)","v":"20619"},null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006",{"$f":"IF(SUM(LEN(C10)-LEN(SUBSTITUTE(C10,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C10,LEN(C10)-5),C10)","v":"20619"},null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852",{"$f":"IF(SUM(LEN(C11)-LEN(SUBSTITUTE(C11,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C11,LEN(C11)-5),C11)","v":"92024"},null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007",{"$f":"IF(SUM(LEN(C12)-LEN(SUBSTITUTE(C12,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C12,LEN(C12)-5),C12)","v":"20619"},null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008",{"$f":"IF(SUM(LEN(C13)-LEN(SUBSTITUTE(C13,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C13,LEN(C13)-5),C13)","v":"20619"},null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000",{"$f":"IF(SUM(LEN(C14)-LEN(SUBSTITUTE(C14,{1,2,3,4,5,6,7,8,9,0},)))>5,\nLEFT(C14,LEN(C14)-5),C14)","v":"90007"},null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"LEFT, MIN & FIND","index":8,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combination of LEFT, MIN and FIND Functions",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR","20619-2001",{"$f":"LEFT(C5,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C5&\"0123456789\"))+4)","v":"20619"},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121",{"$f":"LEFT(C6,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C6&\"0123456789\"))+4)","v":"90007"},null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA","90210-2003",{"$f":"LEFT(C7,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C7&\"0123456789\"))+4)","v":"90210"},null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831",{"$f":"LEFT(C8,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C8&\"0123456789\"))+4)","v":"90007"},null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200","20619-2005",{"$f":"LEFT(C9,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C9&\"0123456789\"))+4)","v":"20619"},null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006",{"$f":"LEFT(C10,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C10&\"0123456789\"))+4)","v":"20619"},null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA","92024-2852",{"$f":"LEFT(C11,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C11&\"0123456789\"))+4)","v":"92024"},null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD","20619-2007",{"$f":"LEFT(C12,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C12&\"0123456789\"))+4)","v":"20619"},null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008",{"$f":"LEFT(C13,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C13&\"0123456789\"))+4)","v":"20619"},null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA","90007-1000",{"$f":"LEFT(C14,MIN(FIND({0,1,2,3,4,5,6,7,8,9},C14&\"0123456789\"))+4)","v":"90007"},null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]

{"sheet":"ISNUMBER, RIGHT, LEFT,LEN","index":9,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,9,1,11]]}
[]
[null,"Combination of ISNUMBER, RIGHT, LEFT and LEN Functions",null,null,null,null,null,null,null,"Do Yourself"]
[]
[null,"California Address","9-Digit ZIP Code","Shortened Code",null,null,null,null,null,"California Address","9-Digit ZIP Code","Shortened Code"]
[null,"44300 POPLAR WOOD DR",206192001,{"$f":"IF(ISNUMBER(RIGHT(C5,8)*1),LEFT(C5,LEN(C5)-4),C5)","v":"20619"},null,null,null,null,null,"44300 POPLAR WOOD DR","20619-2001"]
[null,"PO BOX 7121 , LOS ANGELES, CA",900070121,"90007",null,null,null,null,null,"PO BOX 7121 , LOS ANGELES, CA","90007-0121"]
[null,"Beverly Hills,  LOS ANGELES, CA",902102003,"90210",null,null,null,null,null,"Beverly Hills,  LOS ANGELES, CA","90210-2003"]
[null,"PO BOX 7831 , LOS ANGELES, CA",900070831,"90007",null,null,null,null,null,"PO BOX 7831 , LOS ANGELES, CA","90007-0831"]
[null,"44174 AIRPORT RD #200",206192005,"20619",null,null,null,null,null,"44174 AIRPORT RD #200","20619-2005"]
[null,"801 (From 801 To 899 Odd) ASPEN LN",206192006,"20619",null,null,null,null,null,"801 (From 801 To 899 Odd) ASPEN LN","20619-2006"]
[null,"260-C North El Camino, CA",920242852,"92024",null,null,null,null,null,"260-C North El Camino, CA","92024-2852"]
[null,"44427 AIRPORT RD",206192007,"20619",null,null,null,null,null,"44427 AIRPORT RD","20619-2007"]
[null,"44081 (From 44081 To 44093 Odd) GRANITE WAY",206192008,"20619",null,null,null,null,null,"44081 (From 44081 To 44093 Odd) GRANITE WAY","20619-2008"]
[null,"922 23RD ST , LOS ANGELES, CA",900071000,"90007",null,null,null,null,null,"922 23RD ST , LOS ANGELES, CA","90007-1000"]