The CONCATENATE Function joins up to 255 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 person's first name in cell A1 and the person's last name in cell B1, you can combine the two values in another cell by using the following formula:
The second argument in this example (" ") is a space character. You must specify any spaces or punctuation that you want to appear in the results as an argument that is enclosed in quotation marks.
CONCATENATE(text1, [text2], ...)
Text1 Required. The first text item to be concatenated.
Text2, ... Optional. Additional text items, up to a maximum of 255 items. The items must be separated by commas.
You can also use the ampersand (
&) calculation operator instead of the CONCATENATE function to join text items. For example,
=A1 & B1
returns the same value as
The CONCATENATE Function support up to a maximum of 255 items.
The example may be easier to understand if you copy the example data (include header) in the following table, and paste it in cell A1 of a new Excel worksheet. If you need to, you can adjust the column widths to see all the data.
||Excel Bible||Concatenates the string.|
||Michael Alexander||Concatenates the string.|
||Excel 2019||Concatenates the string.|