This article describes the formula syntax and usage of the CONCATENATE



The CONCATENATE function joins multiple text strings into one text string. The joined items can be text, numbers, cell references, or a combination of those items. For example, if your worksheet contains a product element value in cell A1 and the another product element value in cell B1, you can combine the two values in another cell by using the following formula:


=Header1+" "+ Header2

The second one in this example (" ") is a space character. You must specify any spaces or punctuation that you want to appear in the results as above that is enclosed in quotation marks.

  • Header1 Required. The first text item to be concatenated.

  • Header2 Optional. Additional text items, The items must be concatenated by + operator.

  • Text functions (reference)

Last updated