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, ",", ",
")