CONCATENATE Posted on 24-01-2020 , by: admin , in Uncategorized , 0 Comments previous NEXT Concatenated Name 1Name 2Concatenated Text AlanJonesAlanJones =CONCATENATE(C4,D4)BobWilliamsBobWilliams =CONCATENATE(C5,D5)CarolDaviesCarolDavies =CONCATENATE(C6,D6)AlanJonesAlan Jones =CONCATENATE(C7,” “,D7)BobWilliamsWilliams, Bob =CONCATENATE(D8,”, “,C8)CarolDaviesDavies, Carol =CONCATENATE(D9,”, “,C9) What Does It Do?This function joins separate pieces of text into one item.Syntax=CONCATENATE(Text1,Text2,Text3…Text30)Up to thirty pieces of text can be joined.FormattingNo special formatting is needed, the result will be shown as normal text. Note: You can achieve the same result by using the & operator. Name 1Name 2Concatenated Text AlanJonesAlanJones =C25&D25BobWilliamsBobWilliams =C26&D26CarolDaviesCarolDavies =C27&D27AlanJonesAlan Jones =C28&” “&D28BobWilliamsWilliams, Bob =D29&”, “&C29CarolDaviesDavies, Carol =D30&”, “&C30 previous NEXT