{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["TEXTJOIN Function"," Justify Feature","CONCATENATE and Transpose","with Ampersand","CONCATENATE only","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":"TEXTJOIN Function","index":0,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Combining Multiple Rows in One Cell",null,null,null,null,"Combining Multiple Rows in One Cell"]
[]
[null,"State",null,"Traveler","Visited States",null,"State",null,"Traveler","Visited States"]
[null,"Texas",null,"Tom",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,B6:B9)","v":"Texas, Ohio, New York, Philadelphia"},null,"Texas",null,"Tom"]
[null,"Ohio",null,null,null,null,"Ohio"]
[null,"New York",null,null,null,null,"New York"]
[null,"Philadelphia",null,null,null,null,"Philadelphia"]

{"sheet":" Justify Feature","index":1,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,6,2,7],[5,2,8,2]]}
[]
[]
[null,"Combining Multiple Rows in One Cell",null,null,null,null,"Combining Multiple Rows in One Cell"]
[]
[null,"Split Up","Combined",null,null,null,"Split Up","Combined"]
[null,"Texas","Texas Ohio New York Philadelphia",null,null,null,"Texas","Texas"]
[null,"Ohio",null,null,null,null,"Ohio","Ohio"]
[null,"New York",null,null,null,null,"New York","New York"]
[null,"Philadelphia",null,null,null,null,"Philadelphia","Philadelphia"]

{"sheet":"CONCATENATE and Transpose","index":2,"n_rows":8,"n_cols":7,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6],[5,6,7,6],[5,2,7,2]]}
[]
[]
[null,"Combining Multiple Rows in One Cell",null,null,null,"Combining Multiple Rows in One Cell"]
[]
[null,"Split Up","Combined",null,null,"Split Up","Combined"]
[null,"Alexander",{"$f":"CONCATENATE(\"Alexander\",\" Graham\",\" Bell\")","v":"Alexander Graham Bell"},null,null,"Alexander",{"$f":"CONCATENATE(\"Alexander\",\" Graham\",\" Bell\")","v":"Alexander Graham Bell"}]
[null,"Graham",null,null,null,"Graham"]
[null,"Bell",null,null,null,"Bell"]

{"sheet":"with Ampersand","index":3,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[2,5,2,6]]}
[]
[]
[null,"Combining Multiple Rows in One Cell",null,null,null,"Combining Multiple Rows in One Cell"]
[]
[null,"Student ID","Combination",null,null,"Student ID","Combination"]
[null,56,{"$f":"B6","v":56},null,null,56]
[null,128,{"$f":"C6&\", \"&B7","v":"56, 128"},null,null,128]
[null,12,{"$f":"C7&\", \"&B8","v":"56, 128, 12"},null,null,12]
[null,95,"56, 128, 12, 95",null,null,95]
[null,65,"56, 128, 12, 95, 65",null,null,65]

{"sheet":"CONCATENATE only","index":4,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[2,1,2,4],[4,1,4,3]]}
[]
[]
[null,"Combining Multiple Rows in One Cell"]
[]
[null,"Split Up",null,null,"Combined"]
[null,"Alexander","Graham","Bell",{"$f":"CONCATENATE(B6,\" \",C6,\" \",D6)","v":"Alexander Graham Bell"}]
[null,"Robert","Downy ","Jr.",{"$f":"CONCATENATE(B7,\" \",C7,\" \",D7)","v":"Robert Downy  Jr."}]
[null,"Leonardo","Da","Vinci","Leonardo Da Vinci"]

{"sheet":"VBA","index":5,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[2,1,2,4],[2,6,2,9]]}
[]
[]
[null,"Combining Multiple Rows in One Cell",null,null,null,null,"Combining Multiple Rows in One Cell"]
[]
[null,"State",null,"Traveler","Visited States",null,"State",null,"Traveler","Visited States"]
[null,"Texas",null,"Tom"," Texas Ohio New York Philadelphia",null,"Texas",null,"Tom"]
[null,"Ohio",null,null,null,null,"Ohio"]
[null,"New York",null,null,null,null,"New York"]
[null,"Philadelphia",null,null,null,null,"Philadelphia"]