The Excel CONCAT function concatenates (joins) values supplied as references or constants. Unlike the CONCATENATE function (which CONCAT replaces), CONCAT allows you to supply a range of cells to join, in addition to individual cell references.
Syntax:= CONCAT (text1, [text2], …)
The CONCAT function syntax has the following arguments:
- Text1 : The text1 can be any text or range that you want to concatenate.
- [text2]: This is optional. This also can be any text or range.
Example: Let’s look at some Excel CONCAT function examples and explore how to use the CONCAT function as a worksheet function in Microsoft Excel:
Based on the Excel spreadsheet above, the following CONCAT examples would return:
- CONCAT can accept ranges in addition to individual cells
- To concatenate manually, use the concatenation operator (&)
- The CONCAT Function also provides no options for delimiters or empty values.
- Numbers provided to CONCAT will be converted to text values during concatenation.