Excel Function: CONCATENATE

The Excel function CONCATENATE combines several strings into one.


=CONCATENATE(value_1, value_2, value_3, etc)

Example of use

Select the CONCATENATE function then enter the values to assemble in order:

concatenate function

Click OK to get the result:


Then, simply drag the formula down to complete the other cells:

excel function assemble text concatenate

You can also use & to replace the CONCATENATE function.