Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

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

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 comma at the end of text or numbers in Excel. Let’s get started.


Download Practice Workbook

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


5 Methods to Add Comma in Excel at the End

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. For doing 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

  • Then, press ENTER and drag down the Fill Handle tool for the other cells.

Fill Handle

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

Read More: How to Use Comma in Excel Formula (2 Suitable Ways)


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 Add Comma in Excel to Concatenate Cells (5 Easy Ways)


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 Add a Comma Between City and State in Excel (6 Ways)


Similar Readings


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.

Read More: How to Add Comma Before Text in Excel (6 Suitable Ways)


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 process, 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.

Read More: How to Add Comma in Excel Between Names (4 Suitable Ways)


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: [Fixed!] Style Comma Not Found in Excel (2 Possible Solutions)


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


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 your better understanding, please download the practice sheet. Visit our website, ExcelDemy, a one-stop Excel solution provider, to find out about diverse kinds of Excel methods. Thanks for your patience in reading this article.


Related Articles

Fahim Shahriyar Dipto

Fahim Shahriyar Dipto

Hello! Welcome to my Excel blog! I am a big fan of MS Excel. I am learning new and exciting things in Excel and writing the process here. I think this will be helpful for you to get used to Excel. Keep visiting our website for new and updated Excel methods.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo