Let us assume a case where we need to add a comma after the first word in every cell for a list of names + sport played the person. The list starts from A3 and ends at A7.

Like Excel, Google Sheets makes it easy to split data that's been clearly defined, such as a last name and first name separated by a comma. Follow these steps to separate names in Google Sheets ...