How To Get A New Line In Same Cell In Google Sheets 5 Steps

If you want to see it, then copy the formula and right click on the same cell and apply Paste Special > Value Only.

Go to the cell and type the formula =rept(chart(10),5). It will insert five blank lines in same cell. Apply the paste special as above to see the result. Change the number from 5 to any digit to get additional number of lines.