Quick Navigation
CHAR Function
Summary
The Excel CHAR function converts numeric code page values (1-255) into their corresponding characters based on your computer's character set. Essential for importing data from legacy systems or creating special symbols and control characters in spreadsheets.
Syntax
CHAR(number)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| number | Number |
Yes | Integer between 1 and 255 specifying the character code from your computer's character set |
Using the CHAR Function
CHAR is invaluable for working with text formatting, data imports, and creating dynamic text elements. Use it to insert line breaks within cells, add tabs for alignment, create custom separators, or display special characters that aren't on your keyboard.
Common CHAR Examples
Basic Character Display
=CHAR(65)Returns 'A' (ASCII code 65) - demonstrates basic character lookup
Line Break in Cell
="Line 1"&CHAR(10)&"Line 2"Creates a line break between two lines within a single cell
Tab Character
=CHAR(9)Inserts a horizontal tab character
Exclamation Mark
=CHAR(33)Returns '!' symbol
Custom Separator
=A1&CHAR(168)&B1Joins values with a special currency symbol separator
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Number argument is not between 1 and 255 or not numeric
Solution: Ensure number is an integer from 1 to 255
Blank or invisible result
Cause: Using non-printable control characters (1-31)
Solution: Most control characters aren't visible - use CHAR(9), CHAR(10), CHAR(13) for tabs/newlines
Notes
- CHAR(9) = Tab
- CHAR(10) = Line Feed (line break)
- CHAR(13) = Carriage Return
- CHAR(32) = Space
- Excel web limitations: only supports specific codes
- Common letters: CHAR(65)=A, CHAR(97)=a
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Excel 365, Excel for Web (limited)
Not available in:
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+