Go to cell D2 and Enter CONCATENATE function as below. To get such comments in column D, we need to follow the below steps. The comment we need in column D is like this вЂњThe invoice of certain $ value was due on this MonthвЂќ. Suppose you have the data of a few customers, and you need to enter certain comments for those customers, as given in the below screenshots. We can concatenate the text string even by calculating a certain field. Press the Enter Key, and you will get the desired result.Дrag the formula till the end of the data.Д®xample #4 вЂ“В CONCATENATE Using Calculated Field Now again, Insert the вЂњ &вЂќ operator and give the reference of cell A2 and close the bracket. Now Insert вЂњ &вЂќ operator and comma and space in between the semicolonsвЂќ, вЂњas shown in the below screenshot. Go to cell C2 and give cell reference of cell B2, as shown in the below screenshot. To concatenate the text strings in column A and B with the help of the вЂњ&вЂќ operator, all we need to do is to follow the below steps. Let us take the same example that we used in Example 1, where we want to join the first name and the last name. The way to concatenate is by using the вЂњ&вЂќ operator instead of concatenate function. Example #3 вЂ“В CONCATENATE Using вЂњ&вЂќ Operator Press Enter Key after entering the formula.Дrag down the formula in the below cells to get the mailing address details of other rows.ДЄs you can see in the above screenshot, we have the mailing address in column H for all the persons. Give the reference of cell F6 for Text9.Enter dashвЂќ-вЂќ in between the semicolons for Text8.Give the reference of cell E6 for Text7.Enter commaвЂќ,вЂќ in-between the semicolons for Text6.Give the reference of cell D6 for Text5.Enter commaвЂќ,вЂќ in-between the semicolons for Text4.Give the reference of cell C6 for Text3.Enter space in between the semicolons for Text2.Now give the reference of cell B6 for Text1.Steps for Entering the Concatenate Function. We can do this by simply entering the function in cell F6. The last name followed by the first name will be concatenated in column C2.Дrag down the formula till the end of the data, and the formula will be applied for the rest of the data.Д®xample #2 вЂ“В CONCATENATE Using Direct FormulaДЄs you can see in the below screenshot, we need to concatenate the text in Column A (First Name), Column B (Last Name), Column C (Address), Column D (City) and column E(Zipcode) to arrive at the Mailing address in Column F. Then select a Category as вЂњTEXTвЂќ and then select the Function category will open in which you can select CONCAT Function and Click OK.ДЄ window will open, as shown below after clicking OK, where you can type the text you want to concatenate.ДЇor column C2, in-text 1 gives reference to cell B2, which is the Last Name, Text 2-Put Comma inside semicolons and in Text 3, reference to cell B1, which is the first name.

Concatenate excel