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:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

Leave a Comment

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster