How do I insert line breaks in Calc with Find & Replace?

[The_Ianator]

Using \n does not work in calc as noted here:
http://wiki.openoffice.org/wiki/Documentation/How_Tos/Regular_Expressions_in_Calc

I have a document that has multiple instances of <br> that I wish to replace with a line break, so far all I’ve found through googling is bug reports of \n not working and using CHAR(10) in text formulas.

Does anyone know how I can change all the <br> 's to line breaks?

[w_whalley]

If your text is in cell A1, then you can copy the contents to another cell and replace \ with line breaks with the substitute function, i.e. =SUBSTITUTE(A1,"\",CHAR(10)). Then copy the new cell and paste as text to remove the formula.

[The_Ianator]

Worked perfectly, Thanks.