Excel CONCATENATE Function

In computer terms concatenation is the process of joining two or more strings together to create a word or a group of words. In Excel concatenation is also joining strings or characters in order to create a word or set of words. Below is the syntax for the CONCATENATION( ) function.

    Syntax:

            CONCATENATE(Text1, Text2, ...)

Please view the images and steps below to guide you on how to use the CONCATENATE( ) Function. Remember that only 255 entries are allowed and each text entries must be separated by a comma.

1. Select the cells you want to be added in the function. Enclose the cell address with paragraph and separate them with comma, in the example, cells A1 and B1 are selected.

2.  You will notice that in Cell A3 (where the function resides) the word "HelloThere" will appear since cell A1 contains the word "Hello" and B1 contains "There" and these are the Cell address that is included in the function.












3. If you want to add a space between words, you must put a double quotes (" ") between the cell address. Please refer to the image below on how to create spaces between each text.

4. You must have a result similar to the image below.

This is how basic concatenation in Excel works. Thank You.