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)
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
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.
i like substitute better than the regex quirks you find a lot …
@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.