{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Dataset","Ampersand_withoutSpace","Amersand_Space","CONCATENATE","CONCAT1","CONCAT2","Line Break1","Line Break2_CONCAT","TEXTJOIN1","TEXTJOIN2","Power Query1","PowerQuery2","VBA"],"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":"Dataset","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Dataset"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James ","Smith"]
[null,"Jim ","Brown"]
[null,"Robert ","Smith"]
[null,"Maria ","Garcia"]
[null,"David ","Smith"]
[null,"Liz ","Smith"]
[null,"Mary ","Smith"]
[null,"Maria ","Hernandez"]

{"sheet":"Ampersand_withoutSpace","index":1,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Using Ampersand Symbol (&)"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James","Smith",{"$f":"B5&C5","v":"JamesSmith"}]
[null,"Jim ","Brown",{"$f":"B6&C6","v":"Jim Brown"}]
[null,"Robert","Smith","RobertSmith"]
[null,"Maria","Garcia","MariaGarcia"]
[null,"David","Smith","DavidSmith"]
[null,"Liz","Smith","LizSmith"]
[null,"Mary","Jane","MaryJane"]
[null,"Maria","Hernandez","MariaHernandez"]

{"sheet":"Amersand_Space","index":2,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"Merge Text Using Ampersand Symbol (&) with Space Character"]
[]
[null,"First Name","Last Name","Space","Comma Space","Semi-colon Space"]
[null,"James","Smith",{"$f":"B5&\" \"&C5","v":"James Smith"},{"$f":"B5&\", \"&C5","v":"James, Smith"},{"$f":"B5&\"; \"&C5","v":"James; Smith"}]
[null,"Jim ","Brown",{"$f":"B6&\" \"&C6","v":"Jim  Brown"},{"$f":"B6&\", \"&C6","v":"Jim , Brown"},{"$f":"B6&\"; \"&C6","v":"Jim ; Brown"}]
[null,"Robert","Smith","Robert Smith","Robert, Smith","Robert; Smith"]
[null,"Maria","Garcia","Maria Garcia","Maria, Garcia","Maria; Garcia"]
[null,"David","Smith","David Smith","David, Smith","David; Smith"]
[null,"Liz","Smith","Liz Smith","Liz, Smith","Liz; Smith"]
[null,"Mary","Jane","Mary Jane","Mary, Jane","Mary; Jane"]
[null,"Maria","Hernandez","Maria Hernandez","Maria, Hernandez","Maria; Hernandez"]

{"sheet":"CONCATENATE","index":3,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Using CONCATENATE Function"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James","Smith",{"$f":"CONCATENATE(B5,\" \",C5)","v":"James Smith"}]
[null,"Jim ","Brown",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Jim  Brown"}]
[null,"Robert","Smith","Robert Smith"]
[null,"Maria","Garcia","Maria Garcia"]
[null,"David","Smith","David Smith"]
[null,"Liz","Smith","Liz Smith"]
[null,"Mary","Jane","Mary Jane"]
[null,"Maria","Hernandez","Maria Hernandez"]

{"sheet":"CONCAT1","index":4,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Using CONCAT Function"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James","Smith",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"James Smith"}]
[null,"Jim ","Brown",{"$f":"_xlfn.CONCAT(B6,\" \",C6)","v":"Jim  Brown"}]
[null,"Robert","Smith","Robert Smith"]
[null,"Maria","Garcia","Maria Garcia"]
[null,"David","Smith","David Smith"]
[null,"Liz","Smith","Liz Smith"]
[null,"Mary","Jane","Mary Jane"]
[null,"Maria","Hernandez","Maria Hernandez"]

{"sheet":"CONCAT2","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Range of Text Using CONCAT Function"]
[]
[null,"Text1","Text2","Merged Text"]
[null,"James","Smith",{"$f":"_xlfn.CONCAT(B5:C5,\" \",B6:C6)","v":"JamesSmith StatesOhio"}]
[null,"States","Ohio"]
[null,"Robert","Smith",{"$f":"_xlfn.CONCAT(B7:C7,\" \",B8:C8)","v":"RobertSmith StatesFlorida"}]
[null,"States","Florida"]
[null,"David","Smith",{"$f":"_xlfn.CONCAT(B9:C9,\" \",B10:C10)","v":"DavidSmith StatesAlaska"}]
[null,"States","Alaska"]
[null,"Mary","Jane",{"$f":"_xlfn.CONCAT(B11:C11,\" \",B12:C12)","v":"MaryJane StatesHawaii"}]
[null,"States","Hawaii"]

{"sheet":"Line Break1","index":6,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Keeping Line Break"]
[]
[null,"First Name","Last Name","Merged Full Name with Line Break"]
[null,"James","Smith",{"$f":"B5&CHAR(10)&C5","v":"James\nSmith"}]
[null,"Jim ","Brown","Jim \nBrown"]
[null,"Robert","Smith","Robert\nSmith"]
[null,"Maria","Garcia","Maria\nGarcia"]
[null,"David","Smith","David\nSmith"]
[null,"Liz","Smith","Liz\nSmith"]
[null,"Mary","Jane","Mary\nJane"]
[null,"Maria","Hernandez","Maria\nHernandez"]

{"sheet":"Line Break2_CONCAT","index":7,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Keeping Line Break Using CONCAT Function"]
[]
[null,"Input1","Input2","Merged Text with Line Break"]
[null,"James","Smith",{"$f":"_xlfn.CONCAT(B5,\" \",C5,CHAR(10),B6,\" \",C6)","v":"James Smith\nStates Ohio"}]
[null,"States","Ohio"]
[null,"Robert","Smith",{"$f":"_xlfn.CONCAT(B7,\" \",C7,CHAR(10),B8,\" \",C8)","v":"Robert Smith\nStates Florida"}]
[null,"States","Florida"]
[null,"David","Smith",{"$f":"_xlfn.CONCAT(B9,\" \",C9,CHAR(10),B10,\" \",C10)","v":"David Smith\nStates Alaska"}]
[null,"States","Alaska"]
[null,"Mary","Jane","Mary Jane\nStates Hawaii"]
[null,"States","Hawaii"]

{"sheet":"TEXTJOIN1","index":8,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Utilizing TEXTJOIN Function"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James","Smith",{"$f":"_xlfn.TEXTJOIN(\" \",FALSE,B5,C5)","v":"James Smith"}]
[null,"Jim ","Brown",{"$f":"_xlfn.TEXTJOIN(\" \",FALSE,B6,C6)","v":"Jim  Brown"}]
[null,"Robert",null,"Robert "]
[null,"Maria","Garcia","Maria Garcia"]
[null,"David","Smith","David Smith"]
[null,"Liz","Smith","Liz Smith"]
[null,"Mary",null,"Mary "]
[null,"Maria","Hernandez","Maria Hernandez"]

{"sheet":"TEXTJOIN2","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,5]]}
[]
[null,"TEXTJOIN with IF Condition"]
[]
[null,"Employee","Leisure Time Work",null,"Employee","Leisure Time Work"]
[null,"James","Sports",null,"James",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,IF($B$5:$B$13=E5,$C$5:$C$13,\" \"))","v":"Sports           Politics    "}]
[null,"Jim ","Politics",null,"Jim ",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,IF($B$5:$B$13=E6,$C$5:$C$13,\" \"))","v":"  Politics   Sports   TV Show   Social Media  "}]
[null,"Robert","TV Show",null,"Robert",{"$f":"_xlfn.TEXTJOIN(\" \",TRUE,IF($B$5:$B$13=E7,$C$5:$C$13,\" \"))","v":"    TV Show   Politics       Social Media"}]
[null,"Jim ","Sports"]
[null,"Robert","Politics"]
[null,"Jim ","TV Show"]
[null,"James","Politics"]
[null,"Jim ","Social Media"]
[null,"Robert","Social Media"]

{"sheet":"Power Query1","index":10,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Merge Text Using Powe Query"]
[]
[null,"First Name","Last Name"]
[null,"James","Smith"]
[null,"Jim ","Brown"]
[null,"Robert","Smith"]
[null,"Maria","Garcia"]
[null,"David","Smith"]
[null,"Liz","Smith"]
[null,"Mary","Jane"]
[null,"Maria","Hernandez"]

{"sheet":"PowerQuery2","index":11,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Using Powe Query"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James","Smith","James Smith"]
[null,"Jim ","Brown","Jim  Brown"]
[null,"Robert","Smith","Robert Smith"]
[null,"Maria","Garcia","Maria Garcia"]
[null,"David","Smith","David Smith"]
[null,"Liz","Smith","Liz Smith"]
[null,"Mary","Jane","Mary Jane"]
[null,"Maria","Hernandez","Maria Hernandez"]

{"sheet":"VBA","index":12,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Merge Text Using VBA"]
[]
[null,"First Name","Last Name","Full Name"]
[null,"James","Smith","James Smith "]
[null,"Jim ","Brown",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Jim  Brown"}]
[null,"Robert","Smith",{"$f":"CONCATENATE(B7,\" \",C7)","v":"Robert Smith"}]
[null,"Maria","Garcia",{"$f":"CONCATENATE(B8,\" \",C8)","v":"Maria Garcia"}]
[null,"David","Smith",{"$f":"CONCATENATE(B9,\" \",C9)","v":"David Smith"}]