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 count the number of values in a single cell in Excel and Google Sheets that are seperated by comma using this function or formula.

Is there anyway I can make it so if I copy and paste those comma separated list into it excel it automatically puts each thing into different fields.