How to Use Excel CONCATENATE Function (Examples + Video)

Excel CONCATENATE Function (Example + Video)

Excel CONCATENATE Function

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:

You May Also Like the Following Excel Tutorials:

DOWNLOAD FREE EXCEL EBOOK

51 Excel Tips to Save Time & Increase Productivity

(22,000+ Enthusiasts have Already Downloaded)