CHAR
Returns the character specified by the code number.
TextText Processing
What it does
Returns the character associated with a specific ASCII/ANSI code.
Syntax
CHAR(number)
Arguments
number(number) — Number between 1 and 255.
Examples
Insert Line Break
Combine text with a line break.
FORMULA
="Line 1" & CHAR(10) & "Line 2"
RESULT
Line 1
Line 2
SAMPLE DATA
| A | |
|---|---|
| 1 | Result |
| 2 | Line 1 Line 2 |