Skip to content

How to Use Excel CONCAT Function?

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:

Excel CONCAT FunctionPin
Excel CONCAT Function

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.


  • 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.
Input valuesPin
Input values
  • Then, we have entered the above-mentioned formula in cell E3.
Enter the formulaPin
Enter the formula
  • Once you have entered the formula, you need to click on the Enter button to get the result, as shown below.


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

Read Ahead:


Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...