Newline characters (0x0A, decimal 10) created with Control+Enter in
multiline text cells are now preserved in spreadsheet formulas.
Previously the newline character was replaced by a space character.
The newline character can be searched for using the SEARCH or
[HV]LOOKUP or MATCH functions with the \n regular expression. A
newline character can be inserted in a formula using the CHAR(10)
function. If the result contains newline characters it is displayed as
a multiline cell. The multiline result is exported to file formats
capable handling newlines in cell data, such as CSV.