To use CHAR(10) in a formula you must useconcatenation.
The article below explains two approaches.
CHAR can insert characters that are hard to enter into a formula.
Related videos
How to concatenate with line breaks
Add a line break with a formula
To add a line break with a formula, you can use the CHAR function. In the worksheet shown the formula in F5, copied down, is: =TEXTJOIN(CHAR(10),1,B5:D5) This formula uses the TEXTJOIN function to add line breaks between three text values. See below for another formula that uses manual concatenation with the ampersand (&) operator. Note: To get Excel to respect the line break in a cell, be sure to enable "Wrap text" in the Alignment controls of the Ribbon, or at Format cells > Alignment > Wrap text.
