The newline character in Google Sheets is `CHAR(10)`. Use this with `JOIN` to concatenate a list with newline characters as delimiter. ``` =JOIN(CHAR(10), A1:A) ``` I use this most often to [[concatenate and join]] values from two tables where I want the delimiter to be the newline character.