Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
CHAR
CHAR converts a numeric character code into the corresponding character based on the ASCII/ANSI character set. It is commonly used to insert special characters such as line breaks (CHAR(10)), tabs (CHAR(9)), or symbols into formulas where typing them directly is impractical.
Excel
=CHAR(65)Google Sheets
=CHAR(65)✓
Verified example
Computed by a real spreadsheet engine on the sample data below.
| Code | Character |
| 65 | =CHAR(65) |
| 66 | =CHAR(66) |
| 67 | =CHAR(67) |
| 90 | =CHAR(90) |
=CHAR(65)→A
Try it with your data
Edit the grid or formula, then run it through a real spreadsheet engine — no signup.
Sample data — click any cell to edit
Runs server-side · free · no signup
How it works
- 1Identify the character code you need — for example, 65 for 'A', 10 for a newline, or 9 for a tab.
- 2Enter =CHAR(65) in a cell to produce the letter 'A'.
- 3Combine with other functions, e.g., =A2&CHAR(10)&A3, to insert a line break between two values in a wrapped cell.