{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Contents","concatenate","Age Calculation","Service Calculation"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":1,"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":"Contents","index":0,"n_rows":47,"n_cols":6,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["CONCATENATE Function"]
[null,"automateexcel.com/functions/concatenate-formula-excel"]
[]
[null,"Table of Contents",null,null,null,"Other Resources"]
[null,"concatenate",null,null,null,"Excel Formulas w/Examples"]
[null,"Age Calculation",null,null,null,"Excel Boot Camp - Learn Excel inside Excel"]
[null,"Service Calculation",null,null,null,"Excel Functions & Formulas Tutorial"]
[]
[]
[]
[]
[]
[null,"Excel Boot Camp"]
[null,"  Learn Excel Inside Excel"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"           Learn Excel inside Excel with our Interactive Tutorial"]
[null,"           Automatically Graded Exercises"]
[null,"           Shortcuts & Best Practices \"Work Smarter, not Harder\""]
[]
[]
[]
[]
[]
[]
[]
[null,"Course Contents"]

{"sheet":"concatenate","index":1,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Content!A1"]
[null,"CONCATENATE",null,"=CONCATENATE(text1, [text2], ...)"]
[]
[null,"This function concatenates (joins) join up to 30 text items together and returns the result as text."]
[]
[null,"Text 01","Text 02","Result","Formula"]
[null,"Jeremy","John",{"$f":"CONCATENATE(B7,C7)","v":"JeremyJohn"},{"$f":"IF(_xlfn.ISFORMULA(D7),_xlfn.FORMULATEXT(D7),D7)","v":"=CONCATENATE(B7,C7)"}]
[null,"Jeremy","John",{"$f":"CONCATENATE(B8,\" \",C8)","v":"Jeremy John"},{"$f":"IF(_xlfn.ISFORMULA(D8),_xlfn.FORMULATEXT(D8),D8)","v":"=CONCATENATE(B8,\" \",C8)"}]
[null,"Jeremy","John",{"$f":"CONCATENATE(B9,LEFT(C9,1),\"@ABC.com\")","v":"JeremyJ@ABC.com"},{"$f":"IF(_xlfn.ISFORMULA(D9),_xlfn.FORMULATEXT(D9),D9)","v":"=CONCATENATE(B9,LEFT(C9,1),\"@ABC.com\")"}]
[null,5,10,{"$f":"CONCATENATE(B10,\" Hours \",C10,\" Minutes\")","v":"5 Hours 10 Minutes"},"=CONCATENATE(B10,\" Hours \",C10,\" Minutes\")"]
[null,5,10,{"$f":"CONCATENATE(B11,\" Years \",C11,\" Months\")","v":"5 Years 10 Months"},"=CONCATENATE(B11,\" Years \",C11,\" Months\")"]
[]
[null,"automateexcel.com/functions/concatenate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Age Calculation","index":2,"n_rows":9,"n_cols":3,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Birth day","Age"]
[null,"1987-01-10",{"$f":"CONCATENATE(DATEDIF(B3,TODAY(),\"Y\"),\" Years \",DATEDIF(B3,TODAY(),\"ym\"),\" Months \",DATEDIF(B3,TODAY(),\"md\"),\" Days\")","v":"34 Years 7 Months 21 Days"}]
[null,"1978-08-11","43 Years 0 Months 20 Days"]
[null,"2019-03-10","2 Years 5 Months 21 Days"]
[]
[null,"automateexcel.com/functions/concatenate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]

{"sheet":"Service Calculation","index":3,"n_rows":9,"n_cols":4,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Start Date","End Date","Result"]
[null,"2005-01-10","2020-01-01",{"$f":"CONCATENATE(DATEDIF(B3,C3,\"Y\"),\" Years \",DATEDIF(B3,C3,\"ym\"),\" Months \",DATEDIF(B3,C3,\"md\"),\" Days\")","v":"14 Years 11 Months 22 Days"}]
[null,"2017-08-11","2020-01-31","2 Years 5 Months 20 Days"]
[null,"2019-03-10",{"$f":"TODAY()","v":"2021-08-31"},"2 Years 5 Months 21 Days"]
[]
[null,"automateexcel.com/functions/concatenate-formula-excel"]
[]
[null,"Excel Boot Camp - Learn Excel Inside Excel"]