# CONCATENATE vs CONCAT in Excel (2 Ideal Examples)

Get FREE Advanced Excel Exercises with Solutions!

While working with Excel, you need to use various functions depending on your purpose or criteria. Two such functions are the CONCATENATE function and the CONCAT function of Excel. As they have similarities in their names, their operating processes are also almost the same. But, they do have some similarities between them. In this article, I will show you CONCATENATE vs CONCAT in Excel.

## Introduction to CONCATENATE Function

Summary

The CONCATENATE function in Excel combines multiple text values or numeric values into a single text value.

Syntax

The syntax or formula for this function is,

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

Argument

ARGUMENT REQUIRED OR OPTIONAL VALUE
text1 Required The first value to be joined. Can be any text value, number, cell reference or array of values.
[text2] Optional The second value to be joined. Can be any text value, number, cell reference or an array of values.

Return

After merging all of the arguments, the function returns a combined text value.

## Introduction to CONCAT Function

Summary

The CONCAT function joins the text from different ranges or strings together. However, it doesnâ€™t accept delimiters or ignore empty parameters.

Syntax

The syntax or formula for this function is,

=CONCAT(text1,...)

Argument

ARGUMENT REQUIRED OR OPTIONAL VALUE
text1 Required The first value to be joined. Can be any text value, number, cell reference, or array of values.
[text2] Optional The second value is to be joined. Can be any text value, number, cell reference, or array of values.

Return

The function returns a combined text value after it merges all of the arguments.

Read More: How to Concatenate with Space in Excel

## CONCATENATE vs CONCAT Functions in Excel: 2 Ideal Examples

In this article, you will see two easy examples of CONCATENATE vs CONCAT in Excel. Here, I will differentiate them based on their availability and input criteria. All the other aspects of these two functions are the same. To illustrate the further procedure, I will use the following data set.

### 1. Availability of CONCATENATE and CONCAT Function in Excel

The first difference between these two functions is based on their availability. Users can find the CONCATENATE function in all older versions of Excel from Excel 2007, including the new ones like Microsoft 365. It is the predecessor of the CONCAT function.

On the other hand, you will find the CONCAT function in only the Excel 2019, Excel 2021, and Microsoft 365 versions. They introduced this function to solve the limitations of its predecessor.

### 2. Difference of Input Criteria Between CONCATENATE and CONCAT Function in Excel

The second point will focus on the input criteria of these two functions. In the CONCATENATE function, you can not merge all text values in a range altogether. However, by using the CONCAT function, you can easily perform this task. See the following steps for a clear understanding.

Steps:

• First of all, I will demonstrate the incompatibility of the CONCATENATE function with the cell range as a reference in its formula.
• To do this, in a merged cell, use the following formula in cell B5.
=CONCATENATE(B5:E5)

• Secondly, after pressing Enter, you will get #SPILL as an error.

• Thirdly, I will apply the same formula in an unmerged cell to see if it joins all the given strings in a single cell.

• But, after pressing Enter, you will get the result like the following image where the result will be shown in an equal number of cells that matches the number of reference cells.

• Fifthly, to undo this error, use the above formula in the proper syntax for the CONCATENATE function in cell B5.
=CONCATENATE(B5,C5,D5,E5)

• Consequently, after pressing Enter, you will get the desired result.
• Then, use AutoFill to drag the formula to the lower cells of the column.

• Furthermore, to get this similar result by using the CONCAT function, use the following formula.
• Here, instead of mentioning each of the cells, give the proper cell range to merge the texts.
=CONCAT(B5:E5)

• Lastly, to see if the above formula gives you the desired value press Enter.
• Consequently, to see the results for the lower cells of the column drag the Fill Handle.

## What is ExcelDemy?

ExcelDemy - Learn Excel & Get Excel Solutions Center provides online Excel training , Excel consultancy services , free Excel tutorials, free support , and free Excel Templates for Excel professionals and businesses. Feel free to contact us with your Excel problems.
Md. Araf Bin Jayed

I am Araf. I have completed my B.Sc in Industrial and Production Engineering from Ahsanullah University of Science and Technology. Currently I am working as an Excel & VBA Content Developer in Softeko. With proper guideline and aid of Softeko I want to be a flexible data analyst. With my acquired knowledge and hard work, I want to contribute to the overall growth of this organization.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF