Easy deploying in your enterprise or organization. Combine Workbooks and WorkSheets Merge Tables based on key columns Split Data into Multiple Sheets Batch Convert xls, xlsx and PDF.Super Filter (save and apply filter schemes to other sheets) Advanced Sort by month/week/day, frequency and more Special Filter by bold, italic.Extract Text, Add Text, Remove by Position, Remove Space Create and Print Paging Subtotals Convert Between Cells Content and Comments.Exact Copy Multiple Cells without changing formula reference Auto Create References to Multiple Sheets Insert Bullets, Check Boxes and more.Select Duplicate or Unique Rows Select Blank Rows (all cells are empty) Super Find and Fuzzy Find in Many Workbooks Random Select.Merge Cells/Rows/Columns without losing Data Split Cells Content Combine Duplicate Rows/Columns.Super Formula Bar (easily edit multiple lines of text and formula) Reading Layout (easily read and edit large numbers of cells) Paste to Filtered Range.

Reuse: Quickly insert complex formulas, charts and anything that you have used before Encrypt Cells with password Create Mailing List and send emails.The Best Office Productivity Tools Kutools for Excel Solves Most of Your Problems, and Increases Your Productivity by 80% With this utility, you can quickly add commas at the end of all cells in selected range.

Here will introduce you a handy add-in - Add Text utility of Kutools for Excel. When you copy the formulas to other cells, please paste them as values.Īdd comma at end of cell/text with Kutools for ExcelĪs the above method cannot directly work in the original data. You can change the reference cell in the formula based on your needs.Ģ. You will see commas are added at the end of the text in each cell in the help column.ġ. Select the cell B1, drag the Fill Handle down to the range you need. 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. You need to create a help column for using this formula.ġ. You can use formula to add comma at the end of cell in Excel. In this article, I will show you two methods of adding comma after cells in Excel.Īdd comma at end of cell/text with formulaĮasily add comma at end of cell/text with an amazing tool How to add comma at end of cell/text in Excel?įor some purposes, you may need to add comma at the end of each cell in Excel.

Excel add commas in numbers