How To Use CONCATENATE Function | Microsoft Excel

how to use concatenate function in excel

CONCATENATE Function is used to join two or more text together.You can use also Ampersand (&)

Syntax of CONCATENATE Function


Arguments of CONCATENATE Function

text1: the first value
text2: the second value to join

Behavior of CONCATENATE Function

concatenate function in excel
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(&)

how to use concatenate function

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 CommandsDescription
Shown "
Where " mark applied more than one time
Which is shown in the result
" mark missing in the formula

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.

1 comment:

  1. 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