How to Add Comma in Excel at the End (5 Methods)

Get FREE Advanced Excel Exercises with Solutions!

While working with Excel, sometimes we must put commas in our text. You can easily insert commas in the text using the keyboard. But when you deal with a large dataset, this process will consume a lot of time. So, we should find a way to add commas at the end in Excel. Here, in this article, we will demonstrate to you the methods to add a comma at the end of text or numbers in Excel. Let’s get started.

We have discussed 5 very useful and straightforward methods to add commas at the end in Excel. This method will enlighten you with proper visualization. We have taken a Name dataset and want to add commas at the end.

Dataset

Here, we have used the Microsoft 365 version. You can use any other version at your convenience.


1. Adding the Ampersand (&) Operator

Basically, you can easily add a comma at the end of the text by using the Ampersand (&) operator. Simply, using this method will add commas and save time. To do this, follow the steps stated below.

📌 Steps:

  • First of all, select cell C5 and enter the formula.
=B5&”,”

Here, the Ampersand (&) sign will simply join the comma at the end of the B5 text.

Using the Ampersand (&) Operator to add comma at the end in Excel

Fill Handle

  • Eventually, you will get the texts having commas at the end.

Read More: How to Add Comma Before Text in Excel


2. Employing the CONCATENATE Function

Mainly, the CONCATENATE function adds two or more text strings and makes it to another string. It will perform the operation by assembling the character strings end-to-end. We can add commas at the end by using this function. Follow the steps to get a proper idea.

📌 Steps:

  • In the very beginning, go to cell C5 and insert the formula.
=CONCATENATE(B5,”,”)

Here, this CONCATENATE function will join a text string (comma) at the end of the text of B5.

Employing the CONCATENATE Function to add comma at the end in Excel

  • Consequently, press ENTER and drag the same formula for the other cells to get the result.

Read More: How to Use Comma in Excel Formula


3. Using SUBSTITUTE Function

The SUBSTITUTE function mainly exchanges one text with another one. It replaces a specific character with the string we want to add there. Please, follow the steps for using this function.

📌 Steps:

  • Initially, go to cell C5 and insert the formula.
=SUBSTITUTE(B5,”-“,”,”)

The SUBSTITUTE(B5,”-“,”,”) syntax will replace the text string () with another string (,).

Using SUBSTITUTE Function to add comma a the end in Excel

  • Finally, drag it down to get the results after pressing ENTER.

Read More: How to Insert Comma Between Words in Excel


4. Utilizing TEXTJOIN Function

The TEXTJOIN function joins two or more text strings with a special character. Here we add the texts with commas. We have used a dataset of Students’ Marks with their Student IDs. Now, we will join these three texts with commas. Go through the steps that are stated below.

Dataset

📌 Steps:

  • Firstly, move to cell E5 and write down the formula.
=TEXTJOIN(“,”,TRUE,B5:D5)

This TEXTJOIN(“,”,TRUE,B5:D5) syntax input (,) as delimiter. Then the argument TRUE implies to ignore_empty which means that it will ignore the empty cells. Finally, it will join the texts of B5:D5.

  • Press ENTER.

Utilizing TEXTJOIN Function to add comma at the end in Excel

  • Subsequently, you will get your texts joined with commas.


5. Applying VBA to Add Comma at the End

The VBA Macros can also add a comma at the end of the text. Though it is a complicated process compared to the other processes, we discuss this method to get a good view of every possible way to add commas at the end in Excel. Follow the steps for a better understanding.

📌 Steps:

  • First of all, pick the Developer tab >> select Visual Basic.

Applying VBA to Add Comma at the End in Excel

  • Consequently, a dialog box will appear.
  • Thus, go to Insert tab >> click on Module >> select Module1 >> then write the code in the general box.

Inserting Module to add comma at the end in Excel

  • After that, input the VBA code we stated below.
Public Sub InsertComma()
Dim LastRow As Long, C As Integer, R As Long
C = 2  
LastRow = Cells(Rows.Count, C).End(-4162).Row
Application.ScreenUpdating = False
For R = 5 To LastRow
    Cells(R, C + 1) = Cells(R, C) & "," 
Next
Application.ScreenUpdating = True
End Sub

VBA code to add comma at the end in Excel

  • Then, press the F5 key to run the code.
  • Lastly, you will get the results.


How to Add Comma at the End of Numbers in Excel

Sometimes you have a dataset where the numbers have been added. Now if you want to add commas to these numbers, you can simply use the Comma Style feature to add the commas in the numbers. We have discussed the steps for better visualization.

📌 Steps:

  • Firstly, select the entire data range where you want to put the comma.
  • Then, go to the Home tab and click on the Comma Style command under the Number feature.

How to Add Comma at the End of Numbers in Excel

  • Then. you may need to format the cells according to your preference.
  • Thus, press CTRL + 1 to open the Format Cells dialog box.
  • Afterward, go to Number >> make the Decimal Places 0 >> check the Use 1000 Separator (,) >> click on OK.

Format cells

  • Finally, you will get your results.

Read More: How to Apply Excel Number Format in Thousands with Comma


Practice Section

We have provided a practice section on each sheet on the right side for your practice. Please do it by yourself.

Practice Section


Download Practice Workbook

Download the following practice workbook. It will help you to realize the topic more clearly.


Conclusion

That’s all about today’s session. And these are some easy methods to add commas in Excel at the end. Please let us know in the comments section if you have any questions or suggestions. For a better understanding, please download the practice sheet. Thanks for your patience in reading this article.


Related Articles


<< Go Back to How to Add Comma in Excel | Concatenate Excel | Learn Excel

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.
Fahim Shahriyar Dipto
Fahim Shahriyar Dipto

Fahim Shahriyar Dipto is a graduate of Mechanical Engineering at BUET. With over 1.5 years of experience at Exceldemy, he authored 70+ articles on ExcelDemy. He has expertise in designing worksheets at You’ve Got This Math. Currently, He is a Team Leader at Brainor. Dipto's passion extends to exploring various aspects of Excel. Beyond tech, he enjoys creating engaging kids' worksheets using Illustrator. A dedicated employee and innovative content developer, He incorporates a commitment to academic excellence and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo