Concatenate Formula in Microsoft Excel

In this article, we will learn a Excel function to join cell values.

Excel CONCATENATE function is used combines the values of the cells into a cell.

While working with Excel, we sometimes face issues when we need to join values into a cell. You can either do manually copy data from each cell and then pasting together.

We will use the CONCATENATE function to do this task.

Syntax:

=CONCATENATE(text1, [text2], [text3], …)

Here text1, text2, text3 are the values to be combined.
I have some examples to show how to use concatenate function in Excel.
Here we have some text in cells.
73
In the E2 cell we need the text of A2, B2, C2 and D2 cell combined in E2 cell.

Use the formula

=CONCATENATE(A2,B2,C2,D2)

>74
Press Enter to get the result.
75
Using the same formula in E3 cell for ABCD to be in the cell.
76
As you can see we added values from the cells. We can also add values like strings or special character in the function.

Now we need to add A4, B4, “.” and D4 cell.

Use the formula:

=CONCATENATE(A4,B4,”.”,D4)

77
Now we need to add space in between the cell values.
Use the formula:

=CONCATENATE(A5,B5,” “,C5,” “,D5)

78
Press Enter to get the result.
79
You must be wondering here that why didn’t we used the range of cells together to concatenate values like A2:D2.

Excel introduced a new function CONCAT to add values in the range like A2:D2 instead of adding individual values.
But it’s only available in the Latest version of Office 365 and Excel 2019.

As shown above, we got what we needed to know. Hope you got how to concatenate cell values using the CONCATENATE function. Explore more articles on functions here. Please feel free to add your queries in the comment box below.

Related Articles:

How to Use TEXT Function in Excel

Check A list of Texts In String

Split Numbers and Text from String in Excel

Remove matching characters in Text

Popular Articles:

The VLOOKUP Function in Excel

COUNTIF in Excel 2016

How to Use SUMIF Function in Excel

 

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube