CHAR
TextExcel 2007The character for a code number (e.g. 10 = line break).
Syntax
CHAR(number)
Examples
=A2 & CHAR(10) & B2
→ two lines — Turn on Wrap Text to see the break.
Related functions
More Text functions
Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.