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