Monday, 9 January 2017

How to concatenate in excel

CONCATENATE

Name 1
Name 2
Concatenated Text
Alan
Kerbyson
AlanKerbyson
 =CONCATENATE(C4,D4)
Brian
Beach
BrianBeach
 =CONCATENATE(C5,D5)
Frank
Staniland
FrankStaniland
 =CONCATENATE(C6,D6)
Jan
Semiras
Jan Semiras
 =CONCATENATE(C7," ",D7)
Luke
Collins
Collins, Luke
 =CONCATENATE(D8,", ",C8)
Rita
Narang
Narang, Rita
 =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
Kerbyson
AlanKerbyson
 =C25&D25
Brian
Beach
BrianBeach
 =C26&D26
Frank
Staniland
FrankStaniland
 =C27&D27
Jan
Semiras
Jan Semiras
 =C28&" "&D28
Luke
Collins
Collins, Luke
 =D29&", "&C29
Rita
Narang
Narang, Rita
 =D30&", "&C30

No comments:

Post a Comment