If you need to add a comma after the first word in each cell in Excel using the Replicate or Substitute function, read through this article.

How to combine values into a single cell using TEXTJOIN () in Excel Microsoft 365, Excel 2019 and Excel for the web support the function, TEXTJOIN ().

Learn how to how to increment numbers when value changes in another column. You can automatically fill increment cells in Excel such that the increment value across each cell remains constant.

When you want to combine values in Microsoft Excel, instead of complex expressions or VBA, opt for Power Query – it’s fast and easy.