{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Texts","Numbers","Range of Cells","Column","Space","Comma","Line Break","Date","VBA","Ampersand","CONCATENATE","TEXTJOIN"],"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":"Texts","index":0,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using CONCAT Function with Texts",null,null,null,null,"Try Yourself"]
[]
[null,"Name","Email Address",null,null,null,"Name","Email Address"]
[null,"ethan",{"$f":"_xlfn.CONCAT(B5,\"@gmail.com\")","v":"ethan@gmail.com"},null,null,null,"ethan"]
[null,"olivia",{"$f":"_xlfn.CONCAT(B6,\"@gmail.com\")","v":"olivia@gmail.com"},null,null,null,"olivia"]
[null,"liam","liam@gmail.com",null,null,null,"liam"]
[null,"emi","emi@gmail.com",null,null,null,"emi"]
[null,"noah","noah@gmail.com",null,null,null,"noah"]
[null,"ava","ava@gmail.com",null,null,null,"ava"]
[null,"cameron","cameron@gmail.com",null,null,null,"cameron"]
[null,"sophia","sophia@gmail.com",null,null,null,"sophia"]
[null,"isa","isa@gmail.com",null,null,null,"isa"]
[null,"wendy","wendy@gmail.com",null,null,null,"wendy"]

{"sheet":"Numbers","index":1,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,2],[1,6,1,7]]}
[]
[null,"Using CONCAT Function with Numbers",null,null,null,null,"Try Yourself"]
[]
[null,"Phone Number","Phone Number with Country Code",null,null,null,"Phone Number","Phone Number with Country Code"]
[null,3748296734,{"$f":"_xlfn.CONCAT(\"+1\",B5)","v":"+13748296734"},null,null,null,3748296734]
[null,7482938476,{"$f":"_xlfn.CONCAT(\"+1\",B6)","v":"+17482938476"},null,null,null,7482938476]
[null,6382938256,"+16382938256",null,null,null,6382938256]
[null,2780180076,"+12780180076",null,null,null,2780180076]
[null,2638902873,"+12638902873",null,null,null,2638902873]
[null,2746282903,"+12746282903",null,null,null,2746282903]
[null,3679102947,"+13679102947",null,null,null,3679102947]
[null,5846399836,"+15846399836",null,null,null,5846399836]
[null,5739829473,"+15739829473",null,null,null,5739829473]
[null,2793776902,"+12793776902",null,null,null,2793776902]

{"sheet":"Range of Cells","index":2,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Applying CONCAT Function for Range of Cells",null,null,null,null,null,"Try Yourself"]
[]
[null,"Student ID","Name","ID & Name",null,null,null,"Student ID","Name","ID & Name"]
[null,1610,"Ethan",{"$f":"_xlfn.CONCAT(B5:C5)","v":"1610Ethan"},null,null,null,1610,"Ethan"]
[null,1632,"Olivia",{"$f":"_xlfn.CONCAT(B6:C6)","v":"1632Olivia"},null,null,null,1632,"Olivia"]
[null,1645,"Liam","1645Liam",null,null,null,1645,"Liam"]
[null,1607,"Emi","1607Emi",null,null,null,1607,"Emi"]
[null,1616,"Noah","1616Noah",null,null,null,1616,"Noah"]
[null,1687,"Ava","1687Ava",null,null,null,1687,"Ava"]
[null,1654,"Cameron","1654Cameron",null,null,null,1654,"Cameron"]
[null,1623,"Sophia","1623Sophia",null,null,null,1623,"Sophia"]
[null,1687,"Isa","1687Isa",null,null,null,1687,"Isa"]
[null,1624,"Wendy","1624Wendy",null,null,null,1624,"Wendy"]

{"sheet":"Column","index":3,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using CONCAT Function for All Cells in a Column",null,null,null,null,null,"Try Yourself"]
[]
[null,"Concatenated Data",null,"X",null,null,null,"Concatenated Data",null,"X"]
[null,{"$f":"_xlfn.CONCAT(D:D)","v":"XYZ123RonDanielJacob"},null,"Y",null,null,null,null,null,"Y"]
[null,null,null,"Z",null,null,null,null,null,"Z"]
[]
[null,null,null,1,null,null,null,null,null,1]
[null,null,null,2,null,null,null,null,null,2]
[null,null,null,3,null,null,null,null,null,3]
[]
[null,null,null,"Ron",null,null,null,null,null,"Ron"]
[null,null,null,"Daniel",null,null,null,null,null,"Daniel"]
[null,null,null,"Jacob",null,null,null,null,null,"Jacob"]

{"sheet":"Space","index":4,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using CONCAT Function with Space",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Ethan","Miller",{"$f":"_xlfn.CONCAT(B5,\" \",C5)","v":"Ethan Miller"},null,null,null,"Ethan","Miller"]
[null,"Olivia","Johnson",{"$f":"_xlfn.CONCAT(B6,\" \",C6)","v":"Olivia Johnson"},null,null,null,"Olivia","Johnson"]
[null,"Liam","Anderson","Liam Anderson",null,null,null,"Liam","Anderson"]
[null,"Emi","Martinez","Emi Martinez",null,null,null,"Emi","Martinez"]
[null,"Noah","Thompson","Noah Thompson",null,null,null,"Noah","Thompson"]
[null,"Ava","White","Ava White",null,null,null,"Ava","White"]
[null,"Cameron","Black","Cameron Black",null,null,null,"Cameron","Black"]
[null,"Sophia","Garcia","Sophia Garcia",null,null,null,"Sophia","Garcia"]
[null,"Isabella","Lee","Isabella Lee",null,null,null,"Isabella","Lee"]
[null,"Wendy","Ryan","Wendy Ryan",null,null,null,"Wendy","Ryan"]

{"sheet":"Comma","index":5,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using CONCAT Function with Comma",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Student ID","Name","Department","ID, Name & Department",null,null,null,"Student ID","Name","Department","ID, Name & Department"]
[null,1610,"Ethan","EEE",{"$f":"_xlfn.CONCAT(B5,\",\",C5,\",\",D5)","v":"1610,Ethan,EEE"},null,null,null,1610,"Ethan","EEE"]
[null,1632,"Olivia","ME",{"$f":"_xlfn.CONCAT(B6,\",\",C6,\",\",D6)","v":"1632,Olivia,ME"},null,null,null,1632,"Olivia","ME"]
[null,1645,"Liam","EEE","1645,Liam,EEE",null,null,null,1645,"Liam","EEE"]
[null,1607,"Emi","CSE","1607,Emi,CSE",null,null,null,1607,"Emi","CSE"]
[null,1616,"Noah","ME","1616,Noah,ME",null,null,null,1616,"Noah","ME"]
[null,1687,"Ava","EEE","1687,Ava,EEE",null,null,null,1687,"Ava","EEE"]
[null,1654,"Cameron","CSE","1654,Cameron,CSE",null,null,null,1654,"Cameron","CSE"]
[null,1623,"Sophia","ME","1623,Sophia,ME",null,null,null,1623,"Sophia","ME"]
[null,1687,"Isa","ME","1687,Isa,ME",null,null,null,1687,"Isa","ME"]
[null,1624,"Wendy","EEE","1624,Wendy,EEE",null,null,null,1624,"Wendy","EEE"]

{"sheet":"Line Break","index":6,"n_rows":9,"n_cols":12,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using CONCAT Function with Line Breaks",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Student ID","Name","Department","ID, Name & Department",null,null,null,"Student ID","Name","Department","ID, Name & Department"]
[null,1610,"Ethan","EEE",{"$f":"_xlfn.CONCAT(B5,CHAR(10),C5,CHAR(10),D5)","v":"1610\nEthan\nEEE"},null,null,null,1610,"Ethan","EEE"]
[null,1632,"Olivia","ME",{"$f":"_xlfn.CONCAT(B6,CHAR(10),C6,CHAR(10),D6)","v":"1632\nOlivia\nME"},null,null,null,1632,"Olivia","ME"]
[null,1645,"Liam","EEE","1645\nLiam\nEEE",null,null,null,1645,"Liam","EEE"]
[null,1607,"Emi","CSE","1607\nEmi\nCSE",null,null,null,1607,"Emi","CSE"]
[null,1616,"Noah","ME","1616\nNoah\nME",null,null,null,1616,"Noah","ME"]

{"sheet":"Date","index":7,"n_rows":9,"n_cols":10,"rows_kept":9,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"CONCAT Function with Dates",null,null,null,null,null,"Try Yourself"]
[]
[null,"Department","Date","Date of Result",null,null,null,"Department","Date","Date of Result"]
[null,"EEE","2023-07-17",{"$f":"_xlfn.CONCAT(B5,\" published their result in \",TEXT(C5,\"dd-mm-yyyy\"))","v":"EEE published their result in 17-07-2023"},null,null,null,"EEE","2023-07-17"]
[null,"ME","2023-05-13",{"$f":"_xlfn.CONCAT(B6,\" published their result in \",TEXT(C6,\"dd-mm-yyyy\"))","v":"ME published their result in 13-05-2023"},null,null,null,"ME","2023-05-13"]
[null,"CSE","2023-04-15","CSE published their result in 15-04-2023",null,null,null,"CSE","2023-04-15"]
[null,"CE","2023-06-24","CE published their result in 24-06-2023",null,null,null,"CE","2023-06-24"]
[null,"ECE","2023-07-27","ECE published their result in 27-07-2023",null,null,null,"ECE","2023-07-27"]

{"sheet":"VBA","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using CONCAT Function in VBA",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Ethan","Miller","Ethan Miller",null,null,null,"Ethan","Miller"]
[null,"Olivia","Johnson","Olivia Johnson",null,null,null,"Olivia","Johnson"]
[null,"Liam","Anderson","Liam Anderson",null,null,null,"Liam","Anderson"]
[null,"Emi","Martinez","Emi Martinez",null,null,null,"Emi","Martinez"]
[null,"Noah","Thompson","Noah Thompson",null,null,null,"Noah","Thompson"]
[null,"Ava","White","Ava White",null,null,null,"Ava","White"]
[null,"Cameron","Black","Cameron Black",null,null,null,"Cameron","Black"]
[null,"Sophia","Garcia","Sophia Garcia",null,null,null,"Sophia","Garcia"]
[null,"Isabella","Lee","Isabella Lee",null,null,null,"Isabella","Lee"]
[null,"Wendy","Ryan","Wendy Ryan",null,null,null,"Wendy","Ryan"]

{"sheet":"Ampersand","index":9,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using Ampersand Operator",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Ethan","Miller",{"$f":"B5 & \" \" & C5","v":"Ethan Miller"},null,null,null,"Ethan","Miller"]
[null,"Olivia","Johnson",{"$f":"B6 & \" \" & C6","v":"Olivia Johnson"},null,null,null,"Olivia","Johnson"]
[null,"Liam","Anderson","Liam Anderson",null,null,null,"Liam","Anderson"]
[null,"Emi","Martinez","Emi Martinez",null,null,null,"Emi","Martinez"]
[null,"Noah","Thompson","Noah Thompson",null,null,null,"Noah","Thompson"]
[null,"Ava","White","Ava White",null,null,null,"Ava","White"]
[null,"Cameron","Black","Cameron Black",null,null,null,"Cameron","Black"]
[null,"Sophia","Garcia","Sophia Garcia",null,null,null,"Sophia","Garcia"]
[null,"Isabella","Lee","Isabella Lee",null,null,null,"Isabella","Lee"]
[null,"Wendy","Ryan","Wendy Ryan",null,null,null,"Wendy","Ryan"]

{"sheet":"CONCATENATE","index":10,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,3],[1,7,1,9]]}
[]
[null,"Using CONCATENATE Function",null,null,null,null,null,"Try Yourself"]
[]
[null,"First Name","Last Name","Full Name",null,null,null,"First Name","Last Name","Full Name"]
[null,"Ethan","Miller",{"$f":"CONCATENATE(B5,\" \",C5)","v":"Ethan Miller"},null,null,null,"Ethan","Miller"]
[null,"Olivia","Johnson",{"$f":"CONCATENATE(B6,\" \",C6)","v":"Olivia Johnson"},null,null,null,"Olivia","Johnson"]
[null,"Liam","Anderson","Liam Anderson",null,null,null,"Liam","Anderson"]
[null,"Emi","Martinez","Emi Martinez",null,null,null,"Emi","Martinez"]
[null,"Noah","Thompson","Noah Thompson",null,null,null,"Noah","Thompson"]
[null,"Ava","White","Ava White",null,null,null,"Ava","White"]
[null,"Cameron","Black","Cameron Black",null,null,null,"Cameron","Black"]
[null,"Sophia","Garcia","Sophia Garcia",null,null,null,"Sophia","Garcia"]
[null,"Isabella","Lee","Isabella Lee",null,null,null,"Isabella","Lee"]
[null,"Wendy","Ryan","Wendy Ryan",null,null,null,"Wendy","Ryan"]

{"sheet":"TEXTJOIN","index":11,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,1,4],[1,8,1,11]]}
[]
[null,"Using TEXTJOIN Function",null,null,null,null,null,null,"Try Yourself"]
[]
[null,"Student ID","Name","Department","ID, Name & Department",null,null,null,"Student ID","Name","Department","ID, Name & Department"]
[null,1610,"Ethan","EEE",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,B5:D5)","v":"1610, Ethan, EEE"},null,null,null,1610,"Ethan","EEE"]
[null,1632,"Olivia","ME",{"$f":"_xlfn.TEXTJOIN(\", \",TRUE,B6:D6)","v":"1632, Olivia, ME"},null,null,null,1632,"Olivia","ME"]
[null,1645,"Liam","EEE","1645, Liam, EEE",null,null,null,1645,"Liam","EEE"]
[null,1607,"Emi","CSE","1607, Emi, CSE",null,null,null,1607,"Emi","CSE"]
[null,1616,"Noah","ME","1616, Noah, ME",null,null,null,1616,"Noah","ME"]
[null,1687,"Ava","EEE","1687, Ava, EEE",null,null,null,1687,"Ava","EEE"]
[null,1654,"Cameron","CSE","1654, Cameron, CSE",null,null,null,1654,"Cameron","CSE"]
[null,1623,"Sophia","ME","1623, Sophia, ME",null,null,null,1623,"Sophia","ME"]
[null,1687,"Isa","ME","1687, Isa, ME",null,null,null,1687,"Isa","ME"]
[null,1624,"Wendy","EEE","1624, Wendy, EEE",null,null,null,1624,"Wendy","EEE"]