Concatenated
| 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 |