Google Sheets substitute carriage return

Question

How may I replace the carriage return (new line) in a cell with a comma and a space (", ") using the command SUBSTITUTE or any other suitable command.

As an example I want to change left cell to look like the right cell. Thank you.

Answer 1

char(10) is for newline, so:

=SUBSTITUTE(A1,char(10),", ")