Use of CONCAENATE in Excel

	Name 1	Name 2	Concatenated Text	Formula
	Alan	Jones	AlanJones	=CONCATENATE(C3,D3)
	Bob	Williams	BobWilliams	=CONCATENATE(C4,D4)
	Carol	Davies	CarolDavies	=CONCATENATE(C5,D5)
	Alan	Jones	Alan Jones	=CONCATENATE(C6," ",D6)
	Bob	Williams	Williams, Bob	=CONCATENATE(D7,", ",C7)
	Carol	Davies	Davies, Carol	=CONCATENATE(D8,", ",C8)
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.
Note
You can achieve the same result by using the & operator.
	Name 1	Name 2	Concatenated Text	Formula
	Alan	Jones	AlanJones	=C24&D24
	Bob	Williams	BobWilliams	=C25&D25
	Carol	Davies	CarolDavies	=C26&D26
	Alan	Jones	Alan Jones	=C27&" "&D27
	Bob	Williams	Williams, Bob	=D28&", "&C28
	Carol	Davies	Davies, Carol	=D29&", "&C29