{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Dataset","Use of CHAR Function","Use of CONCATENATE Function","Applying Custom Format","UsingFormulawithAmpersandSymbol","Using Ampersand Operator","ApplyCustomCommandOfFormatCells"," UsingCONCATENATEfunction","CombiningCHARfunction&Ampersand","MergingCONCATENATE&CHARfunction","Syntex Of CHAR","Syntex Of CONCATENATE","DifferentTypesOfData","DifferentTypesOfData (2)","AroundNumbersWithFormulas","SingleQuotesUsingVBA ","DoubleQuotesUsingVBA ","SUBSTITUTE function"],"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":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Dataset"]
[]
[null,"City Name","With Single Quotes"]
[null,"Sydney"]
[null,"Paris"]
[null,"Rome"]
[null,"Melbourne"]
[null,"Copenhagen"]

{"sheet":"Use of CHAR Function","index":1,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of CHAR Function",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","With Single Quotes",null,null,null,null,null,null,null,null,null,"City Name","With Single Quotes"]
[null,"Sydney",{"$f":"CHAR(39)&B5&CHAR(39)","v":"'Sydney'"},null,null,null,null,null,null,null,null,null,"Sydney"]
[null,"Paris",{"$f":"CHAR(39)&B6&CHAR(39)","v":"'Paris'"},null,null,null,null,null,null,null,null,null,"Paris"]
[null,"Rome","'Rome'",null,null,null,null,null,null,null,null,null,"Rome"]
[null,"Melbourne","'Melbourne'",null,null,null,null,null,null,null,null,null,"Melbourne"]
[null,"Copenhagen","'Copenhagen'",null,null,null,null,null,null,null,null,null,"Copenhagen"]

{"sheet":"Use of CONCATENATE Function","index":2,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Use of CONCATENATE Function",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","With Single Quotes",null,null,null,null,null,null,null,null,null,"City Name","With Single Quotes"]
[null,"Sydney",{"$f":"CONCATENATE(\"'\",B5,\"'\")","v":"'Sydney'"},null,null,null,null,null,null,null,null,null,"Sydney"]
[null,"Paris",{"$f":"CONCATENATE(\"'\",B6,\"'\")","v":"'Paris'"},null,null,null,null,null,null,null,null,null,"Paris"]
[null,"Rome","'Rome'",null,null,null,null,null,null,null,null,null,"Rome"]
[null,"Melbourne","'Melbourne'",null,null,null,null,null,null,null,null,null,"Melbourne"]
[null,"Copenhagen","'Copenhagen'",null,null,null,null,null,null,null,null,null,"Copenhagen"]

{"sheet":"Applying Custom Format","index":3,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Applying Custom Format",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","With Single Quotes",null,null,null,null,null,null,null,null,null,"City Name","With Single Quotes"]
[null,"Sydney","Sydney",null,null,null,null,null,null,null,null,null,"Sydney"]
[null,"Paris","Paris",null,null,null,null,null,null,null,null,null,"Paris"]
[null,"Rome","Rome",null,null,null,null,null,null,null,null,null,"Rome"]
[null,"Melbourne","Melbourne",null,null,null,null,null,null,null,null,null,"Melbourne"]
[null,"Copenhagen","Copenhagen",null,null,null,null,null,null,null,null,null,"Copenhagen"]

{"sheet":"UsingFormulawithAmpersandSymbol","index":4,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Using Formula with Ampersand Symbol",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","With Single Quotes",null,null,null,null,null,null,null,null,null,"City Name","With Single Quotes"]
[null,"Sydney",{"$f":"\"'\"&B5&\"'\"","v":"'Sydney'"},null,null,null,null,null,null,null,null,null,"Sydney"]
[null,"Paris",{"$f":"\"'\"&B6&\"'\"","v":"'Paris'"},null,null,null,null,null,null,null,null,null,"Paris"]
[null,"Rome","'Rome'",null,null,null,null,null,null,null,null,null,"Rome"]
[null,"Melbourne","'Melbourne'",null,null,null,null,null,null,null,null,null,"Melbourne"]
[null,"Copenhagen","'Copenhagen'",null,null,null,null,null,null,null,null,null,"Copenhagen"]

{"sheet":"Using Ampersand Operator","index":5,"n_rows":9,"n_cols":15,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Using Ampersand Operator to Add Double Quotes",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Country Name","With Double Quotes",null,null,null,null,null,null,null,null,"City Name","Country Name","With Double Quotes"]
[null,"Sydney","Australia",{"$f":"\"\"\"\"&B5&\"\"\"\"&\" in  \"&\"\"\"\"&C5&\"\"\"\"","v":"\"Sydney\" in  \"Australia\""},null,null,null,null,null,null,null,null,"Sydney","Australia"]
[null,"Paris","France",{"$f":"\"\"\"\"&B6&\"\"\"\"&\" in  \"&\"\"\"\"&C6&\"\"\"\"","v":"\"Paris\" in  \"France\""},null,null,null,null,null,null,null,null,"Paris","France"]
[null,"Rome","Italy","\"Rome\" in  \"Italy\"",null,null,null,null,null,null,null,null,"Rome","Italy"]
[null,"Melbourne","Australia","\"Melbourne\" in  \"Australia\"",null,null,null,null,null,null,null,null,"Melbourne","Australia"]
[null,"Copenhagen","Denmark","\"Copenhagen\" in  \"Denmark\"",null,null,null,null,null,null,null,null,"Copenhagen","Denmark"]

{"sheet":"ApplyCustomCommandOfFormatCells","index":6,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Applying Custom Command of Format Cells",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Country Name",null,null,null,null,null,null,null,null,null,"City Name","Country Name"]
[null,"Sydney","Australia",null,null,null,null,null,null,null,null,null,"Sydney","Australia"]
[null,"Paris","France",null,null,null,null,null,null,null,null,null,"Paris","France"]
[null,"Rome","Italy",null,null,null,null,null,null,null,null,null,"Rome","Italy"]
[null,"Melbourne","Australia",null,null,null,null,null,null,null,null,null,"Melbourne","Australia"]
[null,"Copenhagen","Denmark",null,null,null,null,null,null,null,null,null,"Copenhagen","Denmark"]

{"sheet":" UsingCONCATENATEfunction","index":7,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,13]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Country Name","With Double Quotes",null,null,null,null,null,null,null,null,"City Name","Country Name"]
[null,"Sydney","Australia",{"$f":"CONCATENATE(\"\"\"\",B5,\"\"\"\",\" in  \",\"\"\"\",C5,\"\"\"\")","v":"\"Sydney\" in  \"Australia\""},null,null,null,null,null,null,null,null,"Sydney","Australia"]
[null,"Paris","France",{"$f":"CONCATENATE(\"\"\"\",B6,\"\"\"\",\" in  \",\"\"\"\",C6,\"\"\"\")","v":"\"Paris\" in  \"France\""},null,null,null,null,null,null,null,null,"Paris","France"]
[null,"Rome","Italy","\"Rome\" in  \"Italy\"",null,null,null,null,null,null,null,null,"Rome","Italy"]
[null,"Melbourne","Australia","\"Melbourne\" in  \"Australia\"",null,null,null,null,null,null,null,null,"Melbourne","Australia"]
[null,"Copenhagen","Denmark","\"Copenhagen\" in  \"Denmark\"",null,null,null,null,null,null,null,null,"Copenhagen","Denmark"]

{"sheet":"CombiningCHARfunction&Ampersand","index":8,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,13]]}
[]
[null,"Combining CHAR Function and Ampersand Operator",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Country Name","With Double Quotes",null,null,null,null,null,null,null,null,"City Name","Country Name"]
[null,"Sydney","Australia",{"$f":"CHAR(34)&B5&CHAR(34)&\" in  \"&CHAR(34)&C5&CHAR(34)","v":"\"Sydney\" in  \"Australia\""},null,null,null,null,null,null,null,null,"Sydney","Australia"]
[null,"Paris","France",{"$f":"CHAR(34)&B6&CHAR(34)&\" in  \"&CHAR(34)&C6&CHAR(34)","v":"\"Paris\" in  \"France\""},null,null,null,null,null,null,null,null,"Paris","France"]
[null,"Rome","Italy","\"Rome\" in  \"Italy\"",null,null,null,null,null,null,null,null,"Rome","Italy"]
[null,"Melbourne","Australia","\"Melbourne\" in  \"Australia\"",null,null,null,null,null,null,null,null,"Melbourne","Australia"]
[null,"Copenhagen","Denmark","\"Copenhagen\" in  \"Denmark\"",null,null,null,null,null,null,null,null,"Copenhagen","Denmark"]

{"sheet":"MergingCONCATENATE&CHARfunction","index":9,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,13]]}
[]
[null,"Merging CONCATENATE and CHAR Functions",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Country Name","With Double Quotes",null,null,null,null,null,null,null,null,"City Name","Country Name"]
[null,"Sydney","Australia",{"$f":"CONCATENATE(CHAR(34),B5,CHAR(34),\" in \",CHAR(34),C5,CHAR(34))","v":"\"Sydney\" in \"Australia\""},null,null,null,null,null,null,null,null,"Sydney","Australia"]
[null,"Paris","France",{"$f":"CONCATENATE(CHAR(34),B6,CHAR(34),\" in \",CHAR(34),C6,CHAR(34))","v":"\"Paris\" in \"France\""},null,null,null,null,null,null,null,null,"Paris","France"]
[null,"Rome","Italy","\"Rome\" in \"Italy\"",null,null,null,null,null,null,null,null,"Rome","Italy"]
[null,"Melbourne","Australia","\"Melbourne\" in \"Australia\"",null,null,null,null,null,null,null,null,"Melbourne","Australia"]
[null,"Copenhagen","Denmark","\"Copenhagen\" in \"Denmark\"",null,null,null,null,null,null,null,null,"Copenhagen","Denmark"]

{"sheet":"Syntex Of CHAR","index":10,"n_rows":7,"n_cols":4,"rows_kept":7,"cut":false,"hidden":false,"merged":[[2,1,2,3],[1,1,1,3]]}
[]
[null,"CHAR(number)"]
[null,"Returns the character specified by the code number from the character set for your computer"]
[]
[null,"Formula","Result","Remarks"]
[null,{"$f":"_xlfn.FORMULATEXT(C6)","v":"=CHAR(65)"},{"$f":"CHAR(65)","v":"A"},"Displays the character represented by 65 in the computer's character set."]
[null,{"$f":"_xlfn.FORMULATEXT(C7)","v":"=CHAR(33)"},{"$f":"CHAR(33)","v":"!"},"Displays the character represented by 33 in the computer's character set."]

{"sheet":"Syntex Of CONCATENATE","index":11,"n_rows":7,"n_cols":6,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,1,1,5],[2,1,2,5]]}
[]
[null,"CONCATENATE(text1, [text2], ...)"]
[null,"Joins several text strings into one text string"]
[]
[null,"Data",null,"Formula","Result","Remarks"]
[null,"Sydney",null,{"$f":"_xlfn.FORMULATEXT(E6)","v":"=CONCATENATE(\"'\",B6,\"'\")"},{"$f":"CONCATENATE(\"'\",B6,\"'\")","v":"'Sydney'"},"Displays the text inside single quotes. "]
[null,"Paris",null,{"$f":"_xlfn.FORMULATEXT(E7)","v":"=CONCATENATE(\"'\",B7,\"'\")"},{"$f":"CONCATENATE(\"'\",B7,\"'\")","v":"'Paris'"},"Displays the text inside single quotes. "]

{"sheet":"DifferentTypesOfData","index":12,"n_rows":9,"n_cols":16,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Adding Quotes To Different Types Of Data",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Sales Person","ID No.","Joining Date","Salary",null,null,null,null,null,"City Name","Sales Person","ID No.","Joining Date","Salary"]
[null,"Sydney","Thomas Albert",1001,44228,5400,null,null,null,null,null,"Sydney","Thomas Albert",1001,"2021-02-01",5400]
[null,"Paris","Grant Allen",1002,44621,3500,null,null,null,null,null,"Paris","Grant Allen",1002,"2022-03-01",3500]
[null,"Rome","Max AB Baker",1003,44805,3100,null,null,null,null,null,"Rome","Max AB Baker",1003,"2022-09-01",3100]
[null,"Melbourne","Richard Barr",1004,44228,5000,null,null,null,null,null,"Melbourne","Richard Barr",1004,"2021-02-01",5000]
[null,"Copenhagen","Thea Barron",1005,44774,3000,null,null,null,null,null,"Copenhagen","Thea Barron",1005,"2022-08-01",3000]

{"sheet":"DifferentTypesOfData (2)","index":13,"n_rows":9,"n_cols":17,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,12,1,16]]}
[]
[null,"Adding Quotes To Different Types Of Data",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Sales Person","ID No.","Joining Date","Salary",null,null,null,null,null,null,"City Name","Sales Person","ID No.","Joining Date","Salary"]
[null,"Sydney","Thomas Albert",1001,44228,-5400,null,null,null,null,null,null,"Sydney","Thomas Albert",1001,"2021-02-01",5400]
[null,"Paris","Grant Allen",1002,44621,3500,null,null,null,null,null,null,"Paris","Grant Allen",1002,"2022-03-01",3500]
[null,"Rome","Max AB Baker",1003,44805,3100,null,null,null,null,null,null,"Rome","Max AB Baker",1003,"2022-09-01",3100]
[null,"Melbourne","Richard Barr",1004,44228,5000,null,null,null,null,null,null,"Melbourne","Richard Barr",1004,"2021-02-01",5000]
[null,"Copenhagen","Thea Barron",1005,44774,3000,null,null,null,null,null,null,"Copenhagen","Thea Barron",1005,"2022-08-01",3000]

{"sheet":"AroundNumbersWithFormulas","index":14,"n_rows":16,"n_cols":16,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,11,1,15]]}
[]
[null,"Adding Quotes Around Numbers with Formulas",null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Sales Person","ID No.","Joining Date","Salary",null,null,null,null,null,"City Name","Sales Person","ID No.","Joining Date","Salary"]
[null,"Sydney","Thomas Albert",1001,"2021-02-01",5400,null,null,null,null,null,"Sydney","Thomas Albert",1001,"2021-02-01",5400]
[null,"Paris","Grant Allen",1002,"2022-03-01",3500,null,null,null,null,null,"Paris","Grant Allen",1002,"2022-03-01",3500]
[null,"Rome","Max AB Baker",1003,"2022-09-01",3100,null,null,null,null,null,"Rome","Max AB Baker",1003,"2022-09-01",3100]
[null,"Melbourne","Richard Barr",1004,"2021-02-01",5000,null,null,null,null,null,"Melbourne","Richard Barr",1004,"2021-02-01",5000]
[null,"Copenhagen","Thea Barron",1005,"2022-08-01",3000,null,null,null,null,null,"Copenhagen","Thea Barron",1005,"2022-08-01",3000]
[]
[null,"City Name","Sales Person","ID No.","Joining Date","Salary"]
[null,"Sydney","Thomas Albert",{"$f":"CHAR(34)&D5&CHAR(34)","v":"\"1001\""},{"$f":"CHAR(34)&TEXT(E5, \"dd/mm/yy\")&CHAR(34)","v":"\"01/02/21\""},{"$f":"CHAR(34)&TEXT(F5, \"$#,##0\")&CHAR(34)","v":"\"$5,400\""}]
[null,"Paris","Grant Allen",{"$f":"CHAR(34)&D6&CHAR(34)","v":"\"1002\""},{"$f":"CHAR(34)&TEXT(E6, \"dd/mm/yy\")&CHAR(34)","v":"\"01/03/22\""},{"$f":"CHAR(34)&TEXT(F6, \"$#,##0\")&CHAR(34)","v":"\"$3,500\""}]
[null,"Rome","Max AB Baker",{"$f":"CHAR(34)&D7&CHAR(34)","v":"\"1003\""},"\"01/09/22\"","\"$3,100\""]
[null,"Melbourne","Richard Barr",{"$f":"CHAR(34)&D8&CHAR(34)","v":"\"1004\""},"\"01/02/21\"","\"$5,000\""]
[null,"Copenhagen","Thea Barron",{"$f":"CHAR(34)&D9&CHAR(34)","v":"\"1005\""},"\"01/08/22\"","\"$3,000\""]

{"sheet":"SingleQuotesUsingVBA ","index":15,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Inserting Single Quotes Using VBA ",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","With Single Quotes",null,null,null,null,null,null,null,null,null,"City Name","With Single Quotes"]
[null,"Sydney","'Sydney'",null,null,null,null,null,null,null,null,null,"Sydney"]
[null,"Paris","'Paris'",null,null,null,null,null,null,null,null,null,"Paris"]
[null,"Rome","'Rome'",null,null,null,null,null,null,null,null,null,"Rome"]
[null,"Melbourne","'Melbourne'",null,null,null,null,null,null,null,null,null,"Melbourne"]
[null,"Copenhagen","'Copenhagen'",null,null,null,null,null,null,null,null,null,"Copenhagen"]

{"sheet":"DoubleQuotesUsingVBA ","index":16,"n_rows":9,"n_cols":14,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,12,1,13]]}
[]
[null,"Inserting Double Quotes Using VBA ",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","With Double Quotes",null,null,null,null,null,null,null,null,null,"City Name","With Double Quotes"]
[null,"Sydney","\"Sydney\"",null,null,null,null,null,null,null,null,null,"Sydney"]
[null,"Paris","\"Paris\"",null,null,null,null,null,null,null,null,null,"Paris"]
[null,"Rome","\"Rome\"",null,null,null,null,null,null,null,null,null,"Rome"]
[null,"Melbourne","\"Melbourne\"",null,null,null,null,null,null,null,null,null,"Melbourne"]
[null,"Copenhagen","\"Copenhagen\"",null,null,null,null,null,null,null,null,null,"Copenhagen"]

{"sheet":"SUBSTITUTE function","index":17,"n_rows":16,"n_cols":15,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,12,1,14]]}
[]
[null,"Using Formulas to Remove Quotes",null,null,null,null,null,null,null,null,null,null,"Do it Yourself"]
[]
[null,"City Name","Sales Person","ID No.",null,null,null,null,null,null,null,null,"City Name","Sales Person","ID No."]
[null,"Sydney","Thomas Albert",1001,null,null,null,null,null,null,null,null,"Sydney","Thomas Albert",1001]
[null,"Paris","Grant Allen",1002,null,null,null,null,null,null,null,null,"Paris","Grant Allen",1002]
[null,"Rome","Max AB Baker",1003,null,null,null,null,null,null,null,null,"Rome","Max AB Baker",1003]
[null,"Melbourne","Richard Barr",1004,null,null,null,null,null,null,null,null,"Melbourne","Richard Barr",1004]
[null,"Copenhagen","Thea Barron",1005,null,null,null,null,null,null,null,null,"Copenhagen","Thea Barron",1005]
[]
[null,"City Name","Sales Person","ID No."]
[null,{"$f":"SUBSTITUTE(B5, \"\"\"\", \"\")","v":"Sydney"},{"$f":"SUBSTITUTE(C5, \"\"\"\", \"\")","v":"Thomas Albert"},"1001"]
[null,{"$f":"SUBSTITUTE(B6, \"\"\"\", \"\")","v":"Paris"},"Grant Allen","1002"]
[null,"Rome","Max AB Baker","1003"]
[null,"Melbourne","Richard Barr","1004"]
[null,"Copenhagen","Thea Barron","1005"]