{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Overview","Ampersand","Without","Array","Delimiter","Flash Fill","TEXTJOIN","CONCAT","CONCAT & CHAR","Line Break","& and CHAR","CONCATENATE and CHAR","TEXT","VBA","Table1","Power Query","Separate","Duplicate Name"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"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":12,"n_cols":7,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,6]]}
[]
[null,"How to Concatenate Names in Excel"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names","Formula"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"B5&\" \"&C5","v":"Selina O'Gormley"},{"$f":"_xlfn.FORMULATEXT(F5)","v":"=B5&\" \"&C5"}]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"CONCATENATE(B6,C6)","v":"SusiIvie"},{"$f":"_xlfn.FORMULATEXT(F6)","v":"=CONCATENATE(B6,C6)"}]
[null,"Hanna","Gouldstone","Data Scientist",89189,{"$f":"CONCATENATE(B7,\",\",C7)","v":"Hanna,Gouldstone"},"=CONCATENATE(B7,\",\",C7)"]
[null,"Kessia","Flowerdew","Marketing Manager",60973,{"$f":"CONCATENATE(B8,\" \",C8)","v":"Kessia Flowerdew"},"=CONCATENATE(B8,\" \",C8)"]
[null,"Antonina","Kitson","Project Manager",70197,{"$f":"CONCATENATE(B9,\"-\",C9)","v":"Antonina-Kitson"},"=CONCATENATE(B9,\"-\",C9)"]
[null,"Barbette","Dannohl","Financial Analyst",75533,{"$f":"_xlfn.TEXTJOIN(\" - \",TRUE,B10,C10)","v":"Barbette - Dannohl"},"=TEXTJOIN(\" - \",TRUE,B10,C10)"]
[null,"Shayna","Cumming","Graphic Designer",79424,{"$f":"_xlfn.CONCAT(B11,\" , \",C11)","v":"Shayna , Cumming"},"=CONCAT(B11,\" , \",C11)"]
[null,"Isahella","Sweet","Product Manager",55593,{"$f":"_xlfn.CONCAT(B12,\",\",CHAR(32),C12)","v":"Isahella, Sweet"},"=CONCAT(B12,\",\",CHAR(32),C12)"]

{"sheet":"Ampersand","index":1,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Applying Ampersand Symbol",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"B5&\" \"&C5","v":"Selina O'Gormley"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"B6&\" \"&C6","v":"Susi Ivie"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"Without","index":2,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Application of CONCATENATE Function",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"CONCATENATE(B5,C5)","v":"SelinaO'Gormley"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"CONCATENATE(B6,C6)","v":"SusiIvie"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"HannaGouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"KessiaFlowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"AntoninaKitson",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"BarbetteDannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"ShaynaCumming",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"IsahellaSweet",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"QuintonAthey",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"CeliaArnley",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"GraigVsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"JudasGotcliff",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"Array","index":3,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Use of CONCATENATE Array Formula",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"CONCATENATE(B5:B16,\", \",C5:C16)","v":"Selina, O'Gormley"},null,null,"Selina","O'Gormley","Project Manager",95190,{"$f":"I5&\" \"&J5","v":"Selina O'Gormley"}]
[null,"Susi","Ivie","Software Engineer",57321,"Susi, Ivie",null,null,"Susi","Ivie","Software Engineer",57321,{"$f":"I6&\" \"&J6","v":"Susi Ivie"}]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna, Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone"]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia, Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew"]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina, Kitson",null,null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson"]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette, Dannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl"]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna, Cumming",null,null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming"]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella, Sweet",null,null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet"]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton, Athey",null,null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey"]
[null,"Celia","Arnley","Data Scientist",35829,"Celia, Arnley",null,null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley"]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig, Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli"]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas, Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff"]

{"sheet":"Delimiter","index":4,"n_rows":21,"n_cols":12,"rows_kept":21,"cut":false,"hidden":false,"merged":[[20,3,20,4],[1,1,1,4],[1,7,1,11],[17,3,17,4],[18,3,18,4],[19,3,19,4]]}
[]
[null,"Using CONCATENATE Function with Delimiter",null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,null,null,"Judas","Gotcliff","Creative Director",33459]
[]
[null,"Delimiter","Concatenate Names","Formula"]
[null,"Comma",{"$f":"CONCATENATE(B5,\",\",C5)","v":"Selina,O'Gormley"},{"$f":"_xlfn.FORMULATEXT(C19)","v":"=CONCATENATE(B5,\",\",C5)"}]
[null,"Space",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Susi Ivie"},{"$f":"_xlfn.FORMULATEXT(C20)","v":"=CONCATENATE(B6,\" \",C6)"}]
[null,"Hyphen",{"$f":"CONCATENATE(B7,\"-\",C7)","v":"Hanna-Gouldstone"},"=CONCATENATE(B7,\"-\",C7)"]

{"sheet":"Flash Fill","index":5,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Applying Flash Fill Feature",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,"Selina O'Gormley",null,null,"Selina","O'Gormley","Project Manager",95190,{"$f":"I5&\" \"&J5","v":"Selina O'Gormley"}]
[null,"Susi","Ivie","Software Engineer",57321,"Susi Ivie",null,null,"Susi","Ivie","Software Engineer",57321,{"$f":"I6&\" \"&J6","v":"Susi Ivie"}]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone"]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew"]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson",null,null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson"]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl"]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming",null,null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming"]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet",null,null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet"]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey",null,null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey"]
[null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley",null,null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley"]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli"]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff"]

{"sheet":"TEXTJOIN","index":6,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Application of TEXTJOIN Function",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"_xlfn.TEXTJOIN(\" - \",TRUE,B5,C5)","v":"Selina - O'Gormley"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"_xlfn.TEXTJOIN(\" - \",TRUE,B6,C6)","v":"Susi - Ivie"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna - Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia - Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina - Kitson",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,{"$f":"_xlfn.TEXTJOIN(\" - \",TRUE,B10,C10)","v":"Barbette - Dannohl"},null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna - Cumming",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella - Sweet",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton - Athey",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia - Arnley",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig - Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas - Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"CONCAT","index":7,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Using CONCAT Function",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"_xlfn.CONCAT(B5,\" , \",C5)","v":"Selina , O'Gormley"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"_xlfn.CONCAT(B6,\" , \",C6)","v":"Susi , Ivie"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna , Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia , Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina , Kitson",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette , Dannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,{"$f":"_xlfn.CONCAT(B11,\" , \",C11)","v":"Shayna , Cumming"},null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella , Sweet",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton , Athey",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia , Arnley",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig , Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas , Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"CONCAT & CHAR","index":8,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Combination of CONCAT and CHAR Functions",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"_xlfn.CONCAT(B5,\",\",CHAR(32),C5)","v":"Selina, O'Gormley"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"_xlfn.CONCAT(B6,\",\",CHAR(32),C6)","v":"Susi, Ivie"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna, Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia, Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina, Kitson",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette, Dannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna, Cumming",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,{"$f":"_xlfn.CONCAT(B12,\",\",CHAR(32),C12)","v":"Isahella, Sweet"},null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton, Athey",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia, Arnley",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig, Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas, Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"Line Break","index":9,"n_rows":15,"n_cols":13,"rows_kept":15,"cut":false,"hidden":false,"merged":[[1,8,1,12],[1,1,1,6]]}
[]
[null,"Combination of Ampersand and CHAR Function",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Combine Names","Remarks",null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"B5&CHAR(10)&C5","v":"Selina\nO'Gormley"},{"$f":"B5& \" \"&C5&CHAR(10)& D5 & \"- \" & E5","v":"Selina O'Gormley\nProject Manager- 95190"},null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"B6&CHAR(10)&C6","v":"Susi\nIvie"},{"$f":"B6& \" \"&C6&CHAR(10)& D6 & \"- \" & E6","v":"Susi Ivie\nSoftware Engineer- 57321"},null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna\nGouldstone","Hanna Gouldstone\nData Scientist- 89189",null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia\nFlowerdew","Kessia Flowerdew\nMarketing Manager- 60973",null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina\nKitson","Antonina Kitson\nProject Manager- 70197",null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette\nDannohl","Barbette Dannohl\nFinancial Analyst- 75533",null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna\nCumming","Shayna Cumming\nGraphic Designer- 79424",null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella\nSweet","Isahella Sweet\nProduct Manager- 55593",null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton\nAthey","Quinton Athey\nOperations Manager- 70410",null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia\nArnley","Celia Arnley\nData Scientist- 35829",null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig\nVsanelli","Graig Vsanelli\nResearch Scientist- 98431",null,"Graig","Vsanelli","Research Scientist",98431]

{"sheet":"& and CHAR","index":10,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Combination of Ampersand and CHAR Function",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"B5& \" \"&C5&CHAR(10)& D5 & \"- \" & E5","v":"Selina O'Gormley\nProject Manager- 95190"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"B6& \" \"&C6&CHAR(10)& D6 & \"- \" & E6","v":"Susi Ivie\nSoftware Engineer- 57321"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone\nData Scientist- 89189",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew\nMarketing Manager- 60973",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson\nProject Manager- 70197",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl\nFinancial Analyst- 75533",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming\nGraphic Designer- 79424",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,{"$f":"B12& \" \"&C12&CHAR(10)& D12 & \"- \" & E12","v":"Isahella Sweet\nProduct Manager- 55593"},null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey\nOperations Manager- 70410",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley\nData Scientist- 35829",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli\nResearch Scientist- 98431",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff\nCreative Director- 33459",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"CONCATENATE and CHAR","index":11,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Combining of CONCATENATE and CHAR Functions",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"CONCATENATE(B5& \" \"&C5&CHAR(10)& D5 & \"- \" & E5)","v":"Selina O'Gormley\nProject Manager- 95190"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"CONCATENATE(B6& \" \"&C6&CHAR(10)& D6 & \"- \" & E6)","v":"Susi Ivie\nSoftware Engineer- 57321"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone\nData Scientist- 89189",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew\nMarketing Manager- 60973",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson\nProject Manager- 70197",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl\nFinancial Analyst- 75533",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming\nGraphic Designer- 79424",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet\nProduct Manager- 55593",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey\nOperations Manager- 70410",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley\nData Scientist- 35829",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli\nResearch Scientist- 98431",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff\nCreative Director- 33459",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"TEXT","index":12,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[]
[null,"Use of TEXT Function",null,null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"First Name","Last Name","Designation","Salary","Concatenate Names and Numbers",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,{"$f":"\"Salary of\"&\" \"&B5&\" \"&C5&\" \"&\"is\"&\" \"&TEXT(E5,\"$#,#0.00\")","v":"Salary of Selina O'Gormley is $95,190.00"},null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,{"$f":"\"Salary of\"&\" \"&B6&\" \"&C6&\" \"&\"is\"&\" \"&TEXT(E6,\"$#,#0.00\")","v":"Salary of Susi Ivie is $57,321.00"},null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Salary of Hanna Gouldstone is $89,189.00",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Salary of Kessia Flowerdew is $60,973.00",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Salary of Antonina Kitson is $70,197.00",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Salary of Barbette Dannohl is $75,533.00",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Salary of Shayna Cumming is $79,424.00",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Salary of Isahella Sweet is $55,593.00",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Salary of Quinton Athey is $70,410.00",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Salary of Celia Arnley is $35,829.00",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Salary of Graig Vsanelli is $98,431.00",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Salary of Judas Gotcliff is $33,459.00",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"VBA","index":13,"n_rows":16,"n_cols":13,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5],[1,8,1,12]]}
[null,null,null,null,null," "]
[null,"Run an Excel VBA Code",null,null,null,null,null,null,"<< Try Yourself >>"]
[null,null,null,null,null," "]
[null,"First Name","Last Name","Designation","Salary","First Name Last Name",null,null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina","O'Gormley","Project Manager",95190,"Selina O'Gormley",null,null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321,"Susi Ivie",null,null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone",null,null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew",null,null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson",null,null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl",null,null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming",null,null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet",null,null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey",null,null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley",null,null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli",null,null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff",null,null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"Table1","index":14,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Use of Power Query Editor"]
[]
[null,"First Name","Last Name","Designation","Salary","Merged"]
[null,"Selina","O'Gormley","Project Manager",95190,"Selina O'Gormley"]
[null,"Susi","Ivie","Software Engineer",57321,"Susi Ivie"]
[null,"Hanna","Gouldstone","Data Scientist",89189,"Hanna Gouldstone"]
[null,"Kessia","Flowerdew","Marketing Manager",60973,"Kessia Flowerdew"]
[null,"Antonina","Kitson","Project Manager",70197,"Antonina Kitson"]
[null,"Barbette","Dannohl","Financial Analyst",75533,"Barbette Dannohl"]
[null,"Shayna","Cumming","Graphic Designer",79424,"Shayna Cumming"]
[null,"Isahella","Sweet","Product Manager",55593,"Isahella Sweet"]
[null,"Quinton","Athey","Operations Manager",70410,"Quinton Athey"]
[null,"Celia","Arnley","Data Scientist",35829,"Celia Arnley"]
[null,"Graig","Vsanelli","Research Scientist",98431,"Graig Vsanelli"]
[null,"Judas","Gotcliff","Creative Director",33459,"Judas Gotcliff"]

{"sheet":"Power Query","index":15,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Use of Power Query Editor"]
[]
[null,"First Name","Last Name","Designation","Salary"]
[null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"Separate","index":16,"n_rows":16,"n_cols":12,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,7,1,11],[1,1,1,5]]}
[]
[null,"Separating Names in Excel",null,null,null,null,null,"<< Try Yourself >>"]
[]
[null,"Names","Designation","Salary","First Name","Last Name",null,"First Name","Last Name","Designation","Salary","Concatenate Names"]
[null,"Selina O'Gormley","Project Manager",95190,"Selina","O'Gormley",null,"Selina","O'Gormley","Project Manager",95190]
[null,"Susi Ivie","Software Engineer",57321,"Susi","Ivie",null,"Susi","Ivie","Software Engineer",57321]
[null,"Hanna Gouldstone","Data Scientist",89189,"Hanna","Gouldstone",null,"Hanna","Gouldstone","Data Scientist",89189]
[null,"Kessia Flowerdew","Marketing Manager",60973,"Kessia","Flowerdew",null,"Kessia","Flowerdew","Marketing Manager",60973]
[null,"Antonina Kitson","Project Manager",70197,"Antonina","Kitson",null,"Antonina","Kitson","Project Manager",70197]
[null,"Barbette Dannohl","Financial Analyst",75533,"Barbette","Dannohl",null,"Barbette","Dannohl","Financial Analyst",75533]
[null,"Shayna Cumming","Graphic Designer",79424,"Shayna","Cumming",null,"Shayna","Cumming","Graphic Designer",79424]
[null,"Isahella Sweet","Product Manager",55593,"Isahella","Sweet",null,"Isahella","Sweet","Product Manager",55593]
[null,"Quinton Athey","Operations Manager",70410,"Quinton","Athey",null,"Quinton","Athey","Operations Manager",70410]
[null,"Celia Arnley","Data Scientist",35829,"Celia","Arnley",null,"Celia","Arnley","Data Scientist",35829]
[null,"Graig Vsanelli","Research Scientist",98431,"Graig","Vsanelli",null,"Graig","Vsanelli","Research Scientist",98431]
[null,"Judas Gotcliff","Creative Director",33459,"Judas","Gotcliff",null,"Judas","Gotcliff","Creative Director",33459]

{"sheet":"Duplicate Name","index":17,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,5,1,6]]}
[]
[null,"Merging Duplicate Names",null,null,null,"<< Try Yourself >>"]
[]
[null,"Names","Salary",null,null,"Names","Salary"]
[null,"Selina",95190,null,null,"Selina",95190]
[null,"Susi",57321,null,null,"Susi",57321]
[null,"Hanna",89189,null,null,"Hanna",89189]
[null,"Susi",60973,null,null,"Kessia",60973]
[null,"Antonina",70197,null,null,"Antonina",70197]
[null,"Selina",75533,null,null,"Barbette",75533]
[null,"Shayna",79424,null,null,"Shayna",79424]
[null,"Isahella",55593,null,null,"Isahella",55593]
[null,"Quinton",70410,null,null,"Quinton",70410]
[null,"Hanna",35829,null,null,"Celia",35829]
[null,"Selina",98431,null,null,"Graig",98431]
[null,"Judas",33459,null,null,"Judas",33459]
[]
[null,"Names","Salary",null,null,"Names","Salary"]
[null,"Selina",269154]
[null,"Susi",118294]
[null,"Hanna",125018]
[null,"Antonina",70197]
[null,"Shayna",79424]
[null,"Isahella",55593]
[null,"Quinton",70410]
[null,"Judas",33459]