{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Dataset","Using Ampersand Operator_x0009_","Employing CONCATENATE Function_x0009_","Using SUBSTITUTE Function_x0009_","Utilizing TEXTJOIN Function","Using VBA Macros_x0009_","Using Comma Style_x0009_"],"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":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Sample Dataset"]
[]
[null,"Name","Adding Comma"]
[null,"John"]
[null,"Smith"]
[null,"Kevin"]
[null,"Peter"]
[null,"Harry"]
[null,"Alex"]
[null,"Michael"]
[null,"David"]
[null,"Graham"]

{"sheet":"Using Ampersand Operator_x0009_","index":1,"n_rows":13,"n_cols":11,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,9,1,10]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,null,null,"Practice Section"]
[]
[null,"Name","Adding Comma",null,null,null,null,null,null,"Name","Adding Comma"]
[null,"John",{"$f":"B5&\",\"","v":"John,"},null,null,null,null,null,null,"John"]
[null,"Smith",{"$f":"B6&\",\"","v":"Smith,"},null,null,null,null,null,null,"Smith"]
[null,"Kevin","Kevin,",null,null,null,null,null,null,"Kevin"]
[null,"Peter","Peter,",null,null,null,null,null,null,"Peter"]
[null,"Harry","Harry,",null,null,null,null,null,null,"Harry"]
[null,"Alex","Alex,",null,null,null,null,null,null,"Alex"]
[null,"Michael","Michael,",null,null,null,null,null,null,"Michael"]
[null,"David","David,",null,null,null,null,null,null,"David"]
[null,"Graham","Graham,",null,null,null,null,null,null,"Graham"]

{"sheet":"Employing CONCATENATE Function_x0009_","index":2,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Employing CONCATENATE Function"]
[]
[null,"Name","Adding Comma"]
[null,"John",{"$f":"CONCATENATE(B5,\",\")","v":"John,"}]
[null,"Smith",{"$f":"CONCATENATE(B6,\",\")","v":"Smith,"}]
[null,"Kevin","Kevin,"]
[null,"Peter","Peter,"]
[null,"Harry","Harry,"]
[null,"Alex","Alex,"]
[null,"Michael","Michael,"]
[null,"David","David,"]
[null,"Graham","Graham,"]

{"sheet":"Using SUBSTITUTE Function_x0009_","index":3,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using SUBSTITUTE Function"]
[]
[null,"Name","Adding Comma"]
[null,"John-Terry",{"$f":"SUBSTITUTE(B5,\"-\",\",\")","v":"John,Terry"}]
[null,"Matt-Smith",{"$f":"SUBSTITUTE(B6,\"-\",\",\")","v":"Matt,Smith"}]
[null,"Kevin-Owens","Kevin,Owens"]
[null,"Peter-Salt","Peter,Salt"]
[null,"Mark-Wood","Mark,Wood"]
[null,"Alex-Hooper","Alex,Hooper"]
[null,"Shaun-Michael ","Shaun,Michael "]
[null,"David-Brooks","David,Brooks"]
[null,"Graham-Bell","Graham,Bell"]

{"sheet":"Utilizing TEXTJOIN Function","index":4,"n_rows":13,"n_cols":5,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4]]}
[]
[null,"Utilizing TEXTJOIN Fumction"]
[]
[null,"Student ID","Student","Marks","Product with Comam"]
[null,1010,"John",95,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B5:D5)","v":"1010,John,95"}]
[null,{"$f":"B5+1","v":1011},"Smith",75,{"$f":"_xlfn.TEXTJOIN(\",\",TRUE,B6:D6)","v":"1011,Smith,75"}]
[null,{"$f":"B6+1","v":1012},"Kevin",76,"1012,Kevin,76"]
[null,1013,"Peter",87,"1013,Peter,87"]
[null,1014,"Harry",90,"1014,Harry,90"]
[null,1015,"Alex",93,"1015,Alex,93"]
[null,1016,"Michael",83,"1016,Michael,83"]
[null,1017,"David",84,"1017,David,84"]
[null,1018,"Graham",80,"1018,Graham,80"]

{"sheet":"Using VBA Macros_x0009_","index":5,"n_rows":13,"n_cols":3,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,2]]}
[]
[null,"Using VBA Macros"]
[]
[null,"Name","Adding Comma"]
[null,"John","John,"]
[null,"Smith","Smith,"]
[null,"Kevin","Kevin,"]
[null,"Peter","Peter,"]
[null,"Harry","Harry,"]
[null,"Alex","Alex,"]
[null,"Michael","Michael,"]
[null,"David","David,"]
[null,"Graham","Graham,"]

{"sheet":"Using Comma Style_x0009_","index":6,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,3]]}
[]
[null,"Using Comma Style"]
[]
[null,"Employee","Salary","Salary with Comma"]
[null,"John",35000,35000]
[null,"Smith",39000,39000]
[null,"Kevin",245000,245000]
[null,"Peter",125000,125000]
[null,"Harry",102050,102050]
[null,"Alex",77250,77250]
[null,"Michael",98500,98500]
[null,"David",175250,175250]
[null,"Graham",122300,122300]