google-sheetsnewline

How to match invisible new lines?

I have rows in a spreadsheet that display as such

enter image description here

They all have invisible new lines that are only visible when editing the cell.

enter image description here

I can't figure out how to match them.

\n didn't match. \n only matches when I edit the cell and press enter. They become like this when I do that.

enter image description here

Here's the link to the spreadsheet: https://docs.google.com/spreadsheets/d/1yKkKfhNJOy0pTO53I7wJqIjDruKlb3f_RhSoM6M7L0k/edit?usp=sharing

Solution

  • The end of line character is \r in cells. This is also true in Microsoft Excel.