How to add comma at end of cell/text in Excel?

 In Excel, you might need to add a comma to the end of each cell for specific purposes. I'll demonstrate two ways to add commas after cells in Excel in this article.

In Excel, a comma can be added using a formula. Please carry out the following.

To use this formula, you must create a help column.

1. Select a blank cell such as cell B1 which is adjacent to the cell you want to add comma at end, enter the formula =A1&",", and then press the Enter key. See screenshot:

2. Select the cell B1, drag the Fill Handle down to the range you need. You will see commas are added at the end of the text in each cell in the help column.


1. You can adjust the formula's reference cell to suit your needs.

2. Please paste the formulas as values when you copy them into other cells.

Thank you for adding the comma to the end of the cell or text in Excel.

No comments:

Powered by Blogger.