Adding Comma Character at End of Cells in Excel

This post will guide you how to add a comma character at end of cell or text in Excel. How do I add a comma after each cell with a formula in Excel. How to add comma to end of each cell in Excel.

Adding Comma Character at End of Cells


If you want to add a comma character at end of cells in a range, you just need to use the concatenation operator to create a formula. Like this:

=B1&","

Type this formula in a blank cell, and then press Enter key. And then drag the AutoFill handle over other cells to apply this formula.

add comma at end of cells1

You will see that the comma character has been added at the end of all cells.

 

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar