Numbers: How to use text commands to separate before / after the paragraph return?

I am preparing a database using numbers. I need to separate a text string at the paragraph return. In other words, I have this in a cell (column) and there is a paragraph return separating the two lines:

Consumables > Chai Tea Powder

Big Train Spiced Chai Tea Latte Mix

Simple, right? Just use TEXTBEFORE and TEXTAFTER and insert the paragraph return as the symbol to look for as the dividing point.

Ah, but no. Even though numbers shows that symbol in the cell when I click on it, I cannot copy/paste it! And if I try to enter a 'return' in the formula itself as the thing to search for, it just causes the formula to be engaged (with an error).

So, because it is a character in the cell, it should be able to be found, deleted, or manipulated like any other symbol. But how???

Thanks in advance for any tips!