I need to separate these entries by a comma rather than them be on a new line. Is there a way to do this in google sheets?

enter image description here

CodePudding user response：

Find (for the new-line character) and replace with comma.

CodePudding user response：

try:

=REGEXREPLACE(A1; "\n"; ",")

or:

=SUBSTITUTE(A1; CHAR(10); ",")