OpenOffice: Replace text with new-line

Question

In my OpenOffice spreadsheet, there are cells containing "\n" text.

Each "\n" occurrence needs to be replaced with a new line or line break.

The Find-and-Replace dialog does offer regular expressions when searching. So I can find them using \n but when the replacement is set to \n it replaces the occurrence with the text "\n" instead of a new line.

How can one Find-and-Replace a text into a new line?

Answer 1

Use find and replace to find /n and replace with alt+0013 and alt+0010

Remember if you have a space after your /n that you include that space in the find-and-replace otherwise the new lines will start with a space