Excel Function: CONCATENATE
The Excel function CONCATENATE combines several strings into one.
Usage:
=CONCATENATE(value_1, value_2, value_3, etc)
Example of use
Select the CONCATENATE function then enter the values to assemble in order:
Click OK to get the result:
Then, simply drag the formula down to complete the other cells:
You can also use & to replace the CONCATENATE function.