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.
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.
Here, the Ampersand (&) sign will simply join the comma at the end of the B5 text.
- Then, press ENTER and drag down the Fill Handle tool for the other cells.
- 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.
Here, this CONCATENATE function will join a text string (comma) at the end of the text of B5.
- 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.
The SUBSTITUTE(B5,”-“,”,”) syntax will replace the text string (–) with another string (,).
- 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.
📌 Steps:
- Firstly, move to cell E5 and write down the formula.
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.
- 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.
- Consequently, a dialog box will appear.
- Thus, go to Insert tab >> click on Module >> select Module1 >> then write the code in the general box.
- 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
- 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.
- 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.
- 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.
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
- How to Insert Comma in Excel for Multiple Rows
- How to Add Comma in Excel Between Names
- How to Add a Comma Between City and State in Excel
- How to Add Thousand Separator in Excel Formula
<< Go Back to How to Add Comma in Excel | Concatenate Excel | Learn Excel