Replace Regex - Character to \n (Linefeed) Doesn't Work

asked 2017-01-30 17:38:11 +0200

Kenneth Evans gravatar image

In Calc I have text with spaces in cells. I would like to change the spaces to linefeeds. Using Ctrl-H (Find & Replace) with Find as \s (or a space) and Replace as \n it just replaces the spaces with \n, e.g "aaa bbb" becomes "aaa\nbbb". The same with things like \r or \u000a. I do have Regular Expressions checked. (It does the same whether checked or not.)

Using =SUBSTITUTE(A1," ",CHAR(10) in another cell does what I want, and I can paste (special) the text back to the original cells, but this is tedious, and should not be necessary.

This is LibreOffice 5.2.3.3 on Windows 10 64-bit.

edit retag flag offensive close merge delete

Comments

I can confirm this, and the behaviour is unchanged in V5.3.0.2RC.

Lupp gravatar imageLupp ( 2017-01-30 23:06:47 +0200 )edit