Saturday, 3 September 2016

CONCATE Function | How to use the CONCATE Function



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