Create new lines after comma in google sheets?

user_10159455 0
Viewed 87

I have 2 sheets currently:

  1. One that contains data
  2. A simple "nice view" that fetches data

I'm attempting to create a new line after each comma (if one is present), so it's easier to see if a value has been found.

I am attempting to run regexreplace (substitute) on values from the other worksheet, NOT data on the same sheet. But I just can't get it to work. It just throws back an error.

The formula I currently have is:

=VLOOKUP(B5,'tracking-feb'!A:F,4,false) & =REGEXREPLACE('tracking-feb'!D2:D55, ",", CHAR(10))

I'm trying to fetch the data from here:

enter image description here

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

spreadsheet google-sheets
1 Answers

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