How To Use CONCATENATE Function | Microsoft Excel

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
Shown "	Where " mark applied more than one time Which is shown in the result
#NAME	" 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.