[SOLVED] change any sign into manual line break

asked 2020-08-09 19:24:07 +0100

zm23 gravatar image

updated 2020-10-12 00:04:50 +0100

Alex Kemp gravatar image

How to change any sign, for example @, into manual line break (Ctrl+Enter) with find and replace in Calc? So that as in screenshot A1 will be like A2:

All data is text. If not possible in Calc, I can export as csv to Writer and do it there and import again to Calc.

By the way, Calc automatically changes word in a new line, so that it begins with capital letter. Can this be avoided?

(edit: activated screenshot)

edit retag flag offensive close merge delete

Comments

Hi zm23,

sorry I don't found a replace command for line break in find and replace. But perhaps it is possible for you to use the Substitute function in a separate help column.

=SUBSTITUTE(A1,"@",CHAR(10))

This is not what you are looking for. O.k. But it is better as export and import it in an other application.

best regards

Juergen

dscheikey gravatar imagedscheikey ( 2020-08-09 21:28:20 +0100 )edit

Hi zm23,

to switch off the automatic capitalization at the beginning of a sentence, you can remove the check mark under Tools - AutoCorrect - Options - capitalise first letter every sentence.

dscheikey gravatar imagedscheikey ( 2020-08-09 21:43:27 +0100 )edit

i like substitute better than the regex quirks you find a lot ...

newbie-02 gravatar imagenewbie-02 ( 2020-08-10 05:30:47 +0100 )edit

@dscheikey It works perfectly well. What matters is the end result.

Somehow Writer got crazy when I tried using add-on Alt+Find and Replace to replace @ with \m. It can only change when option regular expression is disabled. But after that it doesn't work as manual break but as normal text.

The conclusion is that using this function is much more simple and convenient solution.

Thank you very much.

zm23 gravatar imagezm23 ( 2020-08-10 12:41:57 +0100 )edit