Home > Blockchain >  Create new lines after comma in google sheets?
Create new lines after comma in google sheets?

Time:02-18

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 - enter image description here

I'm trying to fetch the data from here - enter image description 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, ",", ",
")
  • Related