Skip to main content



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.

Formula Result Description
=CONCATENATE("Excel"," ","Bible") Excel Bible Concatenates the string.
=CONCATENATE("Michael"," ","Alexander") Michael Alexander Concatenates the string.
=CONCATENATE("Excel"," ",2019) Excel 2019 Concatenates the string.
="Excel "&2022 Excel 2022 Using & instead of the CONCATENATE function.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>