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

excell.jpg

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

For some purposes, you may need to add comma at the end of each cell in Excel. In this article, I will show you two methods of adding comma after cells in Excel.

You can use formula to add comma at the end of cell in Excel. Please do as follows.

You need to create a help column for using this formula.

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.

Notes:

1. You can change the reference cell in the formula based on your needs.

2. When you copy the formulas to other cells, please paste them as values.

Congratulations, you have added comma at end of cell/text in Excel

Add comment


Security code
Refresh

SPONSORED

subscribe

 

  • Do you want to be the first to know when we release a new funny video?
  • Do you want to be the first to watch and download our videos when we release them?

Then subscribe to our Youtube channel so as to be the first to watch our videos.

Subscribe to our CHANNEL

Watch Our Comedy

logicman comedy banner