Lesson#14: What is CONCATENATE function
![Lesson#14: What is CONCATENATE function](https://excelabcd.co.in/wp-content/uploads/2017/12/excelabcd-lesson-14-1.png)
CONCATENATE function joins several text strings into one text line. In this post, I will show you some examples of CONCATENATE.
Syntax of CONCATENATE is =CONCATENATE(text1, [text2], …..)
Syntax of CONCATENATE is =CONCATENATE(text1, [text2], …..)
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-1.png)
I made a sheet that shows to enter the NAME, MIDDLE NAME, and SURNAME. In the below-bordered cell, it will show the full name in one line.
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-2.png)
There I entered the formula =CONCATENATE(B4, ” “,C4, ” “,D4). ” ” comma means a space (characters always have to enter within ” “[double inverted comma]).
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-3-1.png)
This is how the CONCATENATE function works.
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-4-1.png)
You can use it for giving a prefix also.
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-6-1.png)
Or you can also use it for making a suffix.
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-7-1.png)
CONCATENATE also can join the digits in cells in one line like text or character.
![](https://excelabcd.co.in/wp-content/uploads/2017/12/Lesson14-8.png)
Related Video Tutorials:
Leave a Reply