| 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 | |||
Monday, August 3, 2015
Excel tutorial - lesson 1- CONCATENATE
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment