How to Use Excel CONCATENATE Function (Examples + Video)

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.

Add a Comment

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