Formatting long strings of text isn’t Google Sheets' strongest suit.
This causes problems when you want to add data to a single cell on multiple lines.
Fortunately, there are various methods you’re free to use to add line breaks in Google Sheets.
Let’s take a look at three simple methods.
As a disclaimer, this won’t add line breaks to your text.
If you take a look at the formula bar, the text is still in a single line.
If you’re a Mac user, you’re free to useCmd+Enterinstead.
The text in the formula bar will have line breaks as well.
you could use this feature to add line breaks in Google Sheets cells.
With CHAR being a function, you’ll have to use it in a formula.
The answer to that question lies in the question itself: Because CHAR is a function!
Thus replacing the spaces with line breaks, and then outputtingA1in multiple lines.
