Create new lines after comma in google sheets?-CodePudding

I have 2 sheets currently, one is a simple "nice view" that just fetches data from another sheet, I'm attempting to create a new line after each comma (if one is present), so it's easier to see. I've tried using regexreplace and substitute but I just can't get it to work. It just throws back an error.

I am attempting to regexreplace / substitute from another work sheet. NOT data on the same sheet.

The formula I currently have is -

I'm trying to fetch the data from here -

edit: I am slightly dumb, so I do apologise in advance.

CodePudding user response：

If by new line you mean a line break (e.g. 1 cell with two lines), you can use Ctrl Enter for Windows or Ctrl Return for Mac to insert a line break. Incorporating that into a formula will look like this:

=REGEXREPLACE(A1, ",", ",
")