Use Of Concatenate

Use Of Concatenate

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

                                                                               मेरी कहानियाँ                      Index          प्रतिदिन सुविचार