CONCATENATE Function in Microsoft Excel

Brief Introduction

             Microsoft Excel Concatenate function is a text function, so this Text function is useful to join up to 30 text items & returns the result as text.

Purpose:

Bind text together.

Syntax of Concatenate Function:

The syntax of CONCATENATE Function in Excel is as follows;

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

Return value:

Joined texts.

Arguments: 

• Text1 - The first text value to join together.

• Text2 - The second text value to join together & so on…..

You can download free the Complete Practice of Concern Topic of Microsoft Excel File, Click on the below download icon,

  

          

              This article explains in simple terms how to use Concatenate Function. It takes a step-by-step approach, & following below contents we will touch in this post.

1. CONCATENATE Function explanation through various examples

Use the CONCATENATE Function to join the multiple texts together.

Let’s start to learn something new about the CONCATENATE Function of Microsoft Excel.                

1.  CONCATENATE Function - Example 1.

        CONCATENATE Function is used to join multiple texts together, as we explain this function through a given below example,

Explanation: - The above given information of a hospital is taken to clarify the CONCATENATE Function, as we see the "Column B", "Column C" & "Column D" contains the information (Text) & "Column E" contains the CONCATENATE Function (Result or return), & we selected the cell "E4" so while using the concatenate function after selecting "text1 cell B4" & "text2 cell C4", we need to Put " –" to separate "text1" from "text2" & "text2" from "text3", so in return we see that concatenate function joined "text1", "text2" & "text3" as "Noah-MD-California".           

In this scenario, we have used a formula like below,

=CONCATENATE(B4,"-",C4,"-",D4)

Example 2.

            In case when we use spaces during CONCATENATE Function then see in below example,

Explanation: - In the above example, we want to explain the CONCATENATE Function, as we see the "Column B", "Column C" & "Column D" contains the information (Text) & "Column E" contains the CONCATENATE Function (Result or return), & we selected the cell "E4" so while using the concatenate function after selecting "text1 cell B4" & "text2 cell C4", we need to Put " " (Spaces) to separate "text1" from "text2" & "text2" from "text3", so in return we see that concatenate function joined "text1", "text2" & "text3" as "Noah MD California".

In this scenario, we have used a formula like below,

=CONCATENATE(B4," ",C4," ",D4)

Example 3.

In case when we use "&" during CONCATENATE Function then see in below example,

Explanation: - In the above example, we want to explain the CONCATENATE Function, as we see the "Column B", "Column C" & "Column D" contains the information (Text) & "Column E" contains the CONCATENATE Function (Result or return), & we selected the cell "E7" so while using the concatenate function after selecting "text1 cell B7" & "text2 cell C7", we need to Put "&" to remove spaces between "text1" to "text2" & "text2" to "text3", so in return we see that concatenate function joined "text1", "text2" & "text3" as " SophiaFemale NurseBrooklyn ".

In this scenario, we have used a formula like below,

=CONCATENATE(B7&C7&D7)

Example 4.

             In case when we use words during CONCATENATE Function then see in below example,

Explanation: - In the above example, we want to explain the CONCATENATE Function, as we see the "Column B" & "Column C" contains the information (Text) & "Column D" contains the CONCATENATE Function (Result or return) & we selected the cell "D7" so while using the concatenate function after selecting "text1 cell B7" & "text2 cell C7", we need to Put " –" to separate "text1" from "text2" & "text2" from "text3" & words we added as text "You Win the Prize of" between the Text1 & text2, so in return we see that concatenate function joined "text1", "text2" & "text3" as " Sophia-You Win the Prize of-4900 ".

In this scenario, we have used a formula like below,

=CONCATENATE(B7,"-","You Win the Prize of","-",C7)