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.
Syntax
=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.
