{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Overview","CHAR","CONCATENATE","Ampersand","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":"Overview","index":0,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Overview of Dataset"]
[]
[null,"Product ","Region","Single Quotes and Comma"]
[null,"Apple","USA",{"$f":"CONCATENATE(CHAR(39), B5, CHAR(39), CHAR(44), CHAR(39), C5, CHAR(39))","v":"'Apple','USA'"}]
[null,"Orange","Canada",{"$f":"CONCATENATE(CHAR(39), B6, CHAR(39), CHAR(44), CHAR(39), C6, CHAR(39))","v":"'Orange','Canada'"}]
[null,"Banana","Spain","'Banana','Spain'"]
[null,"Blackberry","Australia","'Blackberry','Australia'"]
[null,"Cherry","USA","'Cherry','USA'"]
[null,"Avocado","UK","'Avocado','UK'"]

{"sheet":"CHAR","index":1,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Application of CHAR Function"]
[]
[null,"Product ","Region","Single Quotes and Comma"]
[null,"Apple","USA",{"$f":"CHAR(39) & B5 & CHAR(39) &\nCHAR(44) & CHAR(39) & C5 & CHAR(39)","v":"'Apple','USA'"}]
[null,"Orange","Canada",{"$f":"CHAR(39) & B6 & CHAR(39) &\nCHAR(44) & CHAR(39) & C6 & CHAR(39)","v":"'Orange','Canada'"}]
[null,"Banana","Spain","'Banana','Spain'"]
[null,"Blackberry","Australia","'Blackberry','Australia'"]
[null,"Cherry","USA","'Cherry','USA'"]
[null,"Avocado","UK","'Avocado','UK'"]

{"sheet":"CONCATENATE","index":2,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Combination of CONCATENATE and CHAR Functions"]
[]
[null,"Product ","Region","Single Quotes and Comma"]
[null,"Apple","USA",{"$f":"CONCATENATE(CHAR(39), B5, CHAR(39),\nCHAR(44), CHAR(39), C5, CHAR(39))","v":"'Apple','USA'"}]
[null,"Orange","Canada",{"$f":"CONCATENATE(CHAR(39), B6, CHAR(39),\nCHAR(44), CHAR(39), C6, CHAR(39))","v":"'Orange','Canada'"}]
[null,"Banana","Spain","'Banana','Spain'"]
[null,"Blackberry","Australia","'Blackberry','Australia'"]
[null,"Cherry","USA","'Cherry','USA'"]
[null,"Avocado","UK","'Avocado','UK'"]

{"sheet":"Ampersand","index":3,"n_rows":10,"n_cols":4,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Use of Ampersand Symbol"]
[]
[null,"Product ","Region","Single Quotes and Comma"]
[null,"Apple","USA",{"$f":"\"'\"&B5&\"'\"& \",\" &\"'\"&C5&\"'\"","v":"'Apple','USA'"}]
[null,"Orange","Canada",{"$f":"\"'\"&B6&\"'\"& \",\" &\"'\"&C6&\"'\"","v":"'Orange','Canada'"}]
[null,"Banana","Spain","'Banana','Spain'"]
[null,"Blackberry","Australia","'Blackberry','Australia'"]
[null,"Cherry","USA","'Cherry','USA'"]
[null,"Avocado","UK","'Avocado','UK'"]

{"sheet":"VBA","index":4,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Add Single Quotes and Comma Using VBA"]
[]
[null,"Product","Single Quotes and Comma"]
[null,"Apple",{"$f":"ColumntoList(B5:B10)","v":"'Apple','Orange','Banana','Blackberry','Cherry','Avocado'"}]
[null,"Orange"]
[null,"Banana"]
[null,"Blackberry"]
[null,"Cherry"]
[null,"Avocado"]