up vote 1 down vote favorite
share [g+] share [fb]

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?

link|improve this question
you want every cell after each cell with /n to drop down a row? Or do you want line breaks within the cells? – Raystafarian Feb 20 at 18:19
The cells themselves must not shift down. I want line breaks within the cells. Those cells contain text that needs those line breaks – byneri Feb 20 at 18:23
feedback

1 Answer

up vote 1 down vote

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

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.