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.

You can remove leading, trailing, and extra spaces between characters and numbers in Excel using TRIM(), SUBSTITUTE() or Find and Replace.