- Advanced Excel Functions Tutorial
- Advanced Excel Functions - Home
- Compatibility Functions
- Advanced Excel Functions - Cube
- Database Functions
- Date & Time Functions
- Engineering Functions
- Financial Functions
- Information Functions
- Advanced Excel Functions - Logical
- Lookup & Reference Functions
- Math & Trignometric Functions
- Statistical Functions
- Useful Resources
- Quick Guide
- Useful Resources
- Discussion
Statistical - CONCATENATE Function
Description
The CONCATENATE function joins two or more text strings into one string. In Excel 2016, CONCATENATE Function has been replaced with the CONCAT Function. The CONCATENATE Function is still available for backward compatibility.
Syntax
CONCATENATE (text1, [text2] ...)
Arguments
Argument | Description | Required/ Optional |
---|---|---|
text1 | The first item to join. The item can be a text value, number, or cell reference. | Required |
Text2, ... |
Additional text items to join. You can have up to 255 items, up to a total of 8,192 characters. |
Optional |
Notes
Use commas to separate adjoining text items.
Numbers do not need to have quotation marks.
Without designated spaces between separate text entries, the text entries will run together. You can add extra spaces as part of the CONCATENATE formula in two ways −
Add double quotation marks with a space between them " "
Add a space after the Text argument
If quotation marks are missing from a Text argument, CONCATENATE returns #NAME? error value.
Applicability
Excel 2007, Excel 2010, Excel 2013, Excel 2016