Learn How to Use Microsoft Excel CONCAT Function

Microsoft Excel CONCAT Function

The main use of the Microsoft Excel CONCAT function is "join text values without any delimiter." So, it means with the help of the CONCAT function, you can able to join or concatenates values, which are supplied as references or constants. The CONCAT function is different from the CONCATENATE function in which is replaced by the CONCAT. While using the CONCAT function, you can have a range of cells to join in addition to individual cell references.

CONCAT Function Return Value

It will result in a concatenated text.

CONCAT Function Syntax

= CONCAT (text1, [text2], ...)

Where the arguments:

• text1: It is the first text value, cell reference, or range.
• text2: It is the second text value, cell reference, or range (optional).

How to Use Microsoft Excel CONCAT Function?

The CONCAT function is recently introduced in Office 365 and Excel 2019. As we know, the CONCAT function joins or concatenates the values which are supplied as constants or references. With the help of the CONCAT function, you can have the supply of a range of cells to join, in addition to individual cell references. 

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel