Concatenate in Excel

Concatenate in Excel

This function joins separate pieces of text into one item.

Microsoft Excel Function

=CONCATENATE(Text1,Text2,Text3...Text30)                                   

                           

Formatting         

No special formatting is needed, the result will be shown as normal text.

Note

1. Up to thirty pieces of text can be joined.
2. You can achieve the same result by using the ‘&’ operator.

Content Data

Name 1	Name 2	Concatenated Text
Raj	Kumar	RajKumar	=CONCATENATE(C4,D4)
Abhi	Asha	AbhiAsha	=CONCATENATE(C5,D5)
Mohan	Radha	MohanRadha	=CONCATENATE(C6,D6)
Ravi	Kishan	Ravi  Kishan	=CONCATENATE(C7," ",D7)
Hari	Om	Om, Hari	=CONCATENATE(D8,", ",C8)
Tina	Praveen	Praveen, Tina	=CONCATENATE(D9,", ",C9)