CONCATENATE Function is used to join two or more text together.You can use also Ampersand (&)
Syntax of CONCATENATE Function
=CONCATANATE(text1,[text2],...)
Arguments of CONCATENATE Function
text1: the first value
text2: the second value to join
Behavior of CONCATENATE Function
 |
| CONCATENATE Function in Excel |
You can see in the above image of Excel. We have taken three fruit name and make it in one line by using CONCATENATE Function.
We have joined that three fruit name by writing "and" between the reference cell.
Using Ampersand(&)
Here we have used & to joint the values. You have to use " "(Double Quote then Space and then Double Quote) for space between two values.
Usage of CONCATENATE Function
To join two text from the from the cell
Return of CONCATENATE Function
A string of cell.
Error Values
| Error Commands | Description | ||
|
| ||
|
|
How would you like this content to write us in the comment box!
If you face any difficulty in the content feel free to ask!
Thank You.
I must express my gratitude for your kindness supporting men who must have help on your concern. Your special commitment to passing the solution across ended up being wonderfully advantageous and have continually helped many people much like me to get to their aims. Your personal helpful help implies a great deal a person like me and much more to my office workers. Best wishes; from all of us. spreadsheet guru
ReplyDelete