-
Microsoft Excel Office 365
Learn How to Use Microsoft Excel CONCAT Function
In this article, you will learn how to use the Microsoft Excel CONCAT function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel CONCAT function return value and syntax with the help of some examples.
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
Comments