When to use Excel CONCATENATE Function

CONCATENATE function can be used when you want to join 2 or more characters or strings.

What it Returns

It returns the joined text.


=CONCATENATE(text1, [text2], …)

Input Arguments

text1 – the first item to join. The item can be a text value, number, or cell reference. [text2], .. – Additional text items to join. It can handle up to 255 items, up to a total of 8,192 characters.

Additional Notes

Can join a maximum of up to 255 text strings into one text string. Can be used to join text, numbers, cell references, or a combination of these items.

Excel CONCATENATE Function – Live Example

Excel CONCATENATE Function – Video Tutorial

Related Excel Functions:

Excel LEFT Function. Excel LEN Function. Excel MID Function. Excel REPT Function. Excel RIGHT Function. Excel TEXT Function. Excel TRIM Function.

CONCATENATE Excel Ranges (with and without separator). How to Quickly Combine Cells in Excel.