Using the CONCATENATE Worksheet Function

Excel provides a function called CONCATENATE which can be used to combine the contents of several cells, or even to combine cell contents with other text. For instance, let’s say you wanted to add together the contents of cells A3 and B3, separate them by a space, and have the result appear in cell C3. All you need to do is put the following formula in cell C3:

=CONCATENATE(A3," ",B3)

Primarily, the CONCATENATE function is used for compatibility with other (older) spreadsheet programs. You can just as easily use the ampersand (&) operator to combine text values using a formula. For instance, the following is equivalent to the example of CONCATENATE shown above:

=A3 & " " & B3