Ask Your Question

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

asked 2013-09-20 03:15:19 +0200

The_Ianator gravatar image

updated 2013-10-31 15:07:04 +0200

manj_k gravatar image

Using \n does not work in calc as noted here:

I have a document that has multiple instances of \
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 \
's to line breaks?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2015-11-09 09:22:54.133223

1 Answer

Sort by » oldest newest most voted

answered 2013-09-20 16:28:40 +0200

w_whalley gravatar image

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.

edit flag offensive delete link more


Worked perfectly, Thanks.

The_Ianator gravatar imageThe_Ianator ( 2013-09-21 00:38:27 +0200 )edit

Question Tools

1 follower


Asked: 2013-09-20 03:15:19 +0200

Seen: 6,003 times

Last updated: Sep 20 '13