TextLevel: IntermediateAvailable in: Excel 2007+
In this article
- Syntax
- Examples
- Example 1
- Example 2
- Related functions
CHAR returns the character for a code number. CHAR(10) is a line break — the key to multi-line cells built by formula. CODE does the reverse.
Syntax
=CHAR(number)
| Argument |
What it means |
number |
1–255. |
Examples
Example 1
=A2 & CHAR(10) & B2
Name and address on two lines (turn on Wrap Text).
Example 2
=CODE(LEFT(A2))
Find what the “invisible” first character really is.
CLEAN · UNICHAR · CODE
📚 Part of the free Excel course: Beginner → Expert · Try it in the Formula Lab or ask the AI Helper.
✨ Ask AI about this articleStuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong