Monday, August 3, 2015

Excel tutorial - lesson 1- CONCATENATE

CONCATENATE
NAME1 NAME2 Concatenated Text
Alan Jones Alan Jones  =CONCATENATE(C4,D4)
Bob Williams Bob Williams  =CONCATENATE(C5,D5)
Carol Davies Carol Davies  =CONCATENATE(C6,D6)
Alan Jones Alan Jones  =CONCATENATE(C7," ",D7)
Bob Williams Bob Williams  =CONCATENATE(D8,", ",C8)
Carol Davies Carol Davies  =CONCATENATE(D9,", ",C9)
What Does It Do?
This function joins separate pieces of text into one item.
Syntax
 =CONCATENATE(Text1,Text2,Text3...Text30)
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 Alan Jones  =LEFT(C4,D4)
Bob Williams Bob Williams  =LEFT(C5,D5)
Carol Davies Carol Davies  =LEFT(C6,D6)
Alan Jones Alan Jones  =LEFT(C7,D7)
Bob Williams Bob Williams  =LEFT(C8,D8)
Carol Davies Carol Davies

No comments:

Post a Comment