**CONCAT Function in Excel:** We all know that Excel is a powerful spreadsheet program that helps to perform mathematical calculations. It has many in-built formulas and functions for performing operations. With the help of this program, you can do large calculations. On that note, sometimes we want to join data in two cells. For that, Microsoft Excel provides the CONCAT function.

**CONCAT** is a short form of the word CONCATENATION which means it will **merge multiple data into one**. Currently, in Excel, the function CONCATENATION is replaced by the new function called CONCAT. This article describes the **explanation, syntax, and usage of the CONCAT function** in **Excel**. The provided examples will let you understand it even more easily. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

## Jump To

**Explanation of CONCAT Function**

- CONCAT is one of the built-in functions in Excel.
- It helps to join
**two or more text strings**together and returns the result into**one string,**but it doesn’t provide a delimiter or ignore empty cells. - The
**CONCAT**function replaces**CONCATENATE**in newer versions of Excel.

**Syntax**

- Here, you will see the syntax of the CONCAT function.
- To apply this CONCAT function on your spreadsheet, you have to select a cell and enter the formula in the following format.
- Once you enter the formula, just
**click**on the**Enter**button to get the length of the text.

**=CONCAT(text1, [text2], …)**

**Argument Description**

**Text 1(Required):**The first text value to**join****together.****Text 2(Optional):**The second text value to join together.

**Practical Examples**

The** CONCAT Function** and **CONCATENATE Function** are both **similar in Excel**, so here we are using CONCAT Function for illustrating the practical examples.

- Initially, you have to
**open**your**Excel workbook**on your PC and launch a worksheet that has data. - For example, we entered two input values in
**cells B3**and**C3**. - We are going to join those data and get the result in
**cell E3**.

- Then, we have entered the above-mentioned formula in
**cell E3**.

- Once you have entered the formula, you need to
**click**on the**Enter**button to get the result, as shown below.

**Verdict:**

In the above article, we have learned the **explanation, syntax, and usage** of the** CONCAT Function** with a few practical examples. The given example helped you to understand the CONCAT function. If you want to learn more about Excel functions, then visit our webpage Aawexcel.com.

**Read Ahead:**

- How to Use Excel FLOOR.MATH Function?
- How to Use Excel FLOOR Function?
- How to Use Excel CEILING.PRECISE Function?
- How to Use Excel CEILING Function?
- How to Use Excel GCD Function?

**Deepak** is an Excel enthusiast and data analyst with over **5 years** of experience in the field. I’m a renowned author for AAW Excel who connects with a committed group of Excel users by imparting his professional knowledge and helpful advice. No matter your level of Excel proficiency, my articles and tutorials will teach you something new and beneficial. Connect me via my social links!… Mastodon & More!