The CONCAT function was added in Excel 2016 to combine a specified range of text.
It is a new version of the existing CONCATENATE function.
Use the CONCAT function for its improved functionality.
- 1. How it works
- 2. Demonstrate
- 3. Links
- 3.1. Microsoft Excel Functions Text
- 3.2. Examples of Use
How it works
=CONCAT(Text1 to 254)
|Text1 to 254||Required argument.|
Specify the string or cell range to be concatenated.
It is superior to CONCATENATE and & because it can be used to specify a whole range of cells at once.
The function name is also shortened, so use the CONCAT function if there are more than three concatenations.
If numbers are specified, they are concatenated as characters.
The date will be a serial value.
Therefore, dates must be converted to strings with the TEXT function before using the CONCAT function.