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