.

CONCATENATE EXCEL FORMULA


EXCEL FORMULA
Function Dictionary Function Examples Function Categories

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

.

Popular posts from this blog

Tamilnadu SIXTH all books free download, Tamilnadu 6th all books free download

Tamilnadu FIRST STANDARD all books free download, Tamilnadu 1ST STANDARD all books free download