CONCATENATE

Posted on 24-01-2020 , by: admin , in , 0 Comments

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.

Formatting
No 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&D25
BobWilliamsBobWilliams =C26&D26
CarolDaviesCarolDavies =C27&D27
AlanJonesAlan Jones =C28&” “&D28
BobWilliamsWilliams, Bob =D29&”, “&C29
CarolDaviesDavies, Carol =D30&”, “&C30



share:

Leave a comment