CONCATE Function
|
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
|
|
|
|
|
|
|
|
|
|
No comments:
Post a Comment