How to Use Excel CONCAT Function?

Ads

Listen to this article

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

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:

Deepak

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!