{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Overview","Dataset","1.1 Replace Function","1.2 Concatenate Function","1.3 Concatenate MID Function","1.4 TEXT Function","1.5 REPT ","2. Number Format","3.1 VBA","3.2 VBA User Choice"],"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":"Overview","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"The Overview of Adding Space Between Numbers"]
[]
[null,"City","Population","Numbers with Spacing"]
[null,"Norwalk",133546,{"$f":"CONCATENATE(LEFT(C5,3) & \" \" & RIGHT(C5,3))","v":"133 546"}]
[null,"Tuscalooasa",898645,{"$f":"CONCATENATE(LEFT(C6,3) & \" \" & RIGHT(C6,3))","v":"898 645"}]
[null,"Carmel",435298,"435 298"]
[null,"Daly City",774386,"774 386"]
[null,"Edinburg",967422,"967 422"]
[null,"Aurora",123456,"123 456"]

{"sheet":"Dataset","index":1,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Population of US Cities"]
[]
[null,"City","Population"]
[null,"Norwalk",133546]
[null,"Tuscalooasa",898645]
[null,"Carmel",435298]
[null,"Daly City",774386]
[null,"Edinburg",967422]
[null,"Aurora",123456]

{"sheet":"1.1 Replace Function","index":2,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of Replace Function",null,null,null,"Practice Yourself"]
[]
[null,"City","Population","Results",null,"City","Population","Results"]
[null,"Norwalk",133546,{"$f":"REPLACE(C5,4,0,\" \")","v":"133 546"},null,"Norwalk",133546]
[null,"Tuscalooasa",898645,{"$f":"REPLACE(C6,4,0,\" \")","v":"898 645"},null,"Tuscalooasa",898645]
[null,"Carmel",435298,"435 298",null,"Carmel",435298]
[null,"Daly City",774386,"774 386",null,"Daly City",774386]
[null,"Edinburg",967422,"967 422",null,"Edinburg",967422]
[null,"Aurora",123456,"123 456",null,"Aurora",123456]

{"sheet":"1.2 Concatenate Function","index":3,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of CONCATENATE Function",null,null,null,"Practice Yourself"]
[]
[null,"City","Population","Results",null,"City","Population","Results"]
[null,"Norwalk",133546,{"$f":"CONCATENATE(LEFT(C5,3) & \" \" & RIGHT(C5,3))","v":"133 546"},null,"Norwalk",133546]
[null,"Tuscalooasa",898645,{"$f":"CONCATENATE(LEFT(C6,3) & \" \" & RIGHT(C6,3))","v":"898 645"},null,"Tuscalooasa",898645]
[null,"Carmel",435298,"435 298",null,"Carmel",435298]
[null,"Daly City",774386,"774 386",null,"Daly City",774386]
[null,"Edinburg",967422,"967 422",null,"Edinburg",967422]
[null,"Aurora",123456,"123 456",null,"Aurora",123456]

{"sheet":"1.3 Concatenate MID Function","index":4,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of CONCATENATE & MID Functions",null,null,null,"Practice Yourself"]
[]
[null,"City","Population","Results",null,"City","Population","Results"]
[null,"Norwalk",133546,{"$f":"CONCATENATE(LEFT(C5,2)&\" \"&MID(C5,3,2)&\" \"&RIGHT(C5,2))","v":"13 35 46"},null,"Norwalk",133546]
[null,"Tuscalooasa",898645,{"$f":"CONCATENATE(LEFT(C6,2)&\" \"&MID(C6,3,2)&\" \"&RIGHT(C6,2))","v":"89 86 45"},null,"Tuscalooasa",898645]
[null,"Carmel",435298,"43 52 98",null,"Carmel",435298]
[null,"Daly City",774386,"77 43 86",null,"Daly City",774386]
[null,"Edinburg",967422,"96 74 22",null,"Edinburg",967422]
[null,"Aurora",123456,"12 34 56",null,"Aurora",123456]

{"sheet":"1.4 TEXT Function","index":5,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of TEXT Function",null,null,null,"Practice Yourself"]
[]
[null,"City","Population","Results",null,"City","Population","Results"]
[null,"Norwalk",133546,{"$f":"TEXT(C5,\"## ## ##\")","v":"13 35 46"},null,"Norwalk",133546]
[null,"Tuscalooasa",898645,{"$f":"TEXT(C6,\"## ## ##\")","v":"89 86 45"},null,"Tuscalooasa",898645]
[null,"Carmel",435298,"43 52 98",null,"Carmel",435298]
[null,"Daly City",774386,"77 43 86",null,"Daly City",774386]
[null,"Edinburg",967422,"96 74 22",null,"Edinburg",967422]
[null,"Aurora",123456,"12 34 56",null,"Aurora",123456]

{"sheet":"1.5 REPT ","index":6,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,5,1,7]]}
[]
[null,"Use of TEXT, LEN & REPT Functions",null,null,null,"Practice Yourself"]
[]
[null,"City","Population","Results",null,"City","Population","Results"]
[null,"Norwalk",133546,{"$f":"TEXT(C5,REPT(\"0 \",LEN(C5)))","v":"1 3 3 5 4 6 "},null,"Norwalk",133546]
[null,"Tuscalooasa",898645,{"$f":"TEXT(C6,REPT(\"0 \",LEN(C6)))","v":"8 9 8 6 4 5 "},null,"Tuscalooasa",898645]
[null,"Carmel",435298,"4 3 5 2 9 8 ",null,"Carmel",435298]
[null,"Daly City",774386,"7 7 4 3 8 6 ",null,"Daly City",774386]
[null,"Edinburg",967422,"9 6 7 4 2 2 ",null,"Edinburg",967422]
[null,"Aurora",123456,"1 2 3 4 5 6 ",null,"Aurora",123456]

{"sheet":"2. Number Format","index":7,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of Number Format",null,null,"Practice Yourself"]
[]
[null,"City","Population",null,"City","Population"]
[null,"Norwalk",133546,null,"Norwalk",133546]
[null,"Tuscalooasa",898645,null,"Tuscalooasa",898645]
[null,"Carmel",435298,null,"Carmel",435298]
[null,"Daly City",774386,null,"Daly City",774386]
[null,"Edinburg",967422,null,"Edinburg",967422]
[null,"Aurora",123456,null,"Aurora",123456]

{"sheet":"3.1 VBA","index":8,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,4,1,5]]}
[]
[null,"Use of VBA Code",null,null,"Practice Yourself"]
[]
[null,"City","Population",null,"City","Population"]
[null,"Norwalk","1 3 3 5 4 6",null,"Norwalk",133546]
[null,"Tuscalooasa","8 9 8 6 4 5",null,"Tuscalooasa",898645]
[null,"Carmel","4 3 5 2 9 8",null,"Carmel",435298]
[null,"Daly City","7 7 4 3 8 6",null,"Daly City",774386]
[null,"Edinburg","9 6 7 4 2 2",null,"Edinburg",967422]
[null,"Aurora","1 2 3 4 5 6",null,"Aurora",123456]

{"sheet":"3.2 VBA User Choice","index":9,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,6,1,7]]}
[]
[null,"Use of VBA (User's Choice)",null,null,null,null,"Practice Yourself"]
[]
[null,"City","Population","Results","Formula",null,"City","Population"]
[null,"Norwalk",133546,{"$f":"Space(C5,2)","v":"13 3546"},{"$f":"_xlfn.FORMULATEXT(D5)","v":"=Space(C5,2)"},null,"Norwalk",133546]
[null,"Tuscalooasa",898645,{"$f":"Space(C6,3)","v":"898 645"},{"$f":"_xlfn.FORMULATEXT(D6)","v":"=Space(C6,3)"},null,"Tuscalooasa",898645]
[null,"Carmel",435298,{"$f":"Space(C7,1)","v":"4 35298"},"=Space(C7,1)",null,"Carmel",435298]
[null,"Daly City",774386,{"$f":"Space(C8,4)","v":"7743 86"},"=Space(C8,4)",null,"Daly City",774386]
[null,"Edinburg",967422,{"$f":"Space(C9,1)","v":"9 67422"},"=Space(C9,1)",null,"Edinburg",967422]
[null,"Aurora",123456,{"$f":"Space(C10,2)","v":"12 3456"},"=Space(C10,2)",null,"Aurora",123456]