CONCATENATE Function (Functions in Excel)

Name 1	Name 2	Concatenated Text
Alan	Jones	AlanJones	=CONCATENATE(C4,D4)
Bob	Williams	BobWilliams	=CONCATENATE(C5,D5)
Carol	Davies	CarolDavies	=CONCATENATE(C6,D6)
Alan	Jones	Alan Jones	=CONCATENATE(C7," ",D7)
Bob	Williams	Williams, Bob	=CONCATENATE(D8,", ",C8)
Carol	Davies	Davies, 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 1	Name 2	Concatenated Text
Alan	Jones	AlanJones	=C25&D25
Bob	Williams	BobWilliams	=C26&D26
Carol	Davies	CarolDavies	=C27&D27
Alan	Jones	Alan Jones	=C28&" "&D28
Bob	Williams	Williams, Bob	=D29&", "&C29
Carol	Davies	Davies, Carol	=D30&", "&C30

Related Posts by Categories