When the data is entered it looks very nice and neat with line breaks at the end of lines.
However, when I refer to the text in code, even though not removing line, they are gone and the text no longer looks neat
How can I keep the correct format with the line breaks?
Can you write which formula made your line breaks disappear?
And, can you share a (dummy) doc and/or tell us a bit more: is the screenshot from a table, a canvas column, or…?
I do quite a bit of text manipulation and I always keep the linebreaks. In some situations you have to add them back by using a spit(", ").join(linebreak()) type function, but that is generally when processing multiple rows or lists.