{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Dataset","Ampersand","CHAR","CONCATENATE and CHAR","Format Cells","VBA"],"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":"Dataset","index":0,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset Overview"]
[]
[null,"Employee","Department","With Single Quotes"]
[null,"Alex","Sales"]
[null,"Paul","Sales"]
[null,"John","Sales"]
[null,"Sam","Accounting"]
[null,"Tom","Accounting"]

{"sheet":"Ampersand","index":1,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of Ampersand (&) Operator",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","With Single Quotes",null,null,null,null,"Employee","Department","With Single Quotes"]
[null,"Alex","Sales",{"$f":"\"'\"&C5&\"'\"","v":"'Sales'"},null,null,null,null,"Alex","Sales"]
[null,"Paul","Sales",{"$f":"\"'\"&C6&\"'\"","v":"'Sales'"},null,null,null,null,"Paul","Sales"]
[null,"John","Sales","'Sales'",null,null,null,null,"John","Sales"]
[null,"Sam","Accounting","'Accounting'",null,null,null,null,"Sam","Accounting"]
[null,"Tom","Accounting","'Accounting'",null,null,null,null,"Tom","Accounting"]

{"sheet":"CHAR","index":2,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Use of CHAR Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","With Single Quotes",null,null,null,null,"Employee","Department","With Single Quotes"]
[null,"Alex","Sales",{"$f":"CHAR(39)&C5&CHAR(39)","v":"'Sales'"},null,null,null,null,"Alex","Sales"]
[null,"Paul","Sales",{"$f":"CHAR(39)&C6&CHAR(39)","v":"'Sales'"},null,null,null,null,"Paul","Sales"]
[null,"John","Sales",{"$f":"CHAR(39)&C7&CHAR(39)","v":"'Sales'"},null,null,null,null,"John","Sales"]
[null,"Sam","Accounting","'Accounting'",null,null,null,null,"Sam","Accounting"]
[null,"Tom","Accounting","'Accounting'",null,null,null,null,"Tom","Accounting"]

{"sheet":"CONCATENATE and CHAR","index":3,"n_rows":9,"n_cols":11,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,8,1,10]]}
[]
[null,"Combination of CONCATENATE and CHAR Functions",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department","With Single Quotes",null,null,null,null,"Employee","Department","With Single Quotes"]
[null,"Alex","Sales",{"$f":" CONCATENATE(CHAR(39),C5,CHAR(39))","v":"'Sales'"},null,null,null,null,"Alex","Sales"]
[null,"Paul","Sales",{"$f":" CONCATENATE(CHAR(39),C6,CHAR(39))","v":"'Sales'"},null,null,null,null,"Paul","Sales"]
[null,"John","Sales","'Sales'",null,null,null,null,"John","Sales"]
[null,"Sam","Accounting","'Accounting'",null,null,null,null,"Sam","Accounting"]
[null,"Tom","Accounting","'Accounting'",null,null,null,null,"Tom","Accounting"]

{"sheet":"Format Cells","index":4,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Use of Format Cells Dialog Box",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department",null,null,null,null,null,null,null,null,"Employee","Department"]
[null,"Alex","Sales",null,null,null,null,null,null,null,null,"Alex","Sales"]
[null,"Paul","Sales",null,null,null,null,null,null,null,null,"Paul","Sales"]
[null,"John","Sales",null,null,null,null,null,null,null,null,"John","Sales"]
[null,"Sam","Accounting",null,null,null,null,null,null,null,null,"Sam","Accounting"]
[null,"Tom","Accounting",null,null,null,null,null,null,null,null,"Tom","Accounting"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":13,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,11,1,12]]}
[]
[null,"Application of VBA",null,null,null,null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Employee","Department",null,null,null,null,null,null,null,null,"Employee","Department"]
[null,"Alex","Sales",null,null,null,null,null,null,null,null,"Alex","Sales"]
[null,"Paul","Sales",null,null,null,null,null,null,null,null,"Paul","Sales"]
[null,"John","Sales",null,null,null,null,null,null,null,null,"John","Sales"]
[null,"Sam","Accounting",null,null,null,null,null,null,null,null,"Sam","Accounting"]
[null,"Tom","Accounting",null,null,null,null,null,null,null,null,"Tom","Accounting"]