Concatenate Formula
This function joins
separate pieces of text into one item.
|
|
|
|
|
|
|
|
|
|
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
|
|
|