How to How to Use CHAR Function in Excel in Excel - Practical Guide

Learn how to use the CHAR function to convert numeric character codes (1-255) into their corresponding characters in Excel. This function is essential for working with special characters, symbols, and ASCII codes programmatically within formulas, enabling dynamic text generation and data manipulation.

Why This Matters

CHAR is vital for inserting special characters, creating line breaks, and automating text formatting without manual character insertion. It's indispensable for cleaning data and generating complex text strings dynamically.

Prerequisites

•Basic understanding of Excel formulas and cell references
•Familiarity with ASCII character codes or numeric values

Step-by-Step Instructions

Open Excel and select a target cell

Launch Excel, create a new workbook, and click on the cell where you want the result to appear (e.g., cell A1).

Type the CHAR formula

Enter the formula =CHAR(65) where 65 is the numeric code for the character you want (65 = 'A'). Type directly into the cell or formula bar.

Press Enter to execute

Press Enter to confirm the formula; the cell will display the corresponding character (e.g., 'A' for code 65).

Use with cell references

Replace the hardcoded number with a cell reference like =CHAR(A1) if the numeric code is stored in another cell, enabling dynamic character conversion.

Combine with other functions

Nest CHAR within CONCATENATE, IF, or other functions for advanced text generation, such as =CONCATENATE('Item',CHAR(10),'Description') to insert line breaks.

Alternative Methods

Using UNICHAR for Unicode characters

In newer Excel versions (2016+), use =UNICHAR() for extended character sets beyond ASCII (codes 256+). This function supports international characters and symbols.

Direct character entry with Alt codes

Hold Alt and type numeric codes on the numeric keypad to insert special characters directly, though this is less scalable for formulas and automation.

Tips & Tricks

✓CHAR code 10 creates a line break; use it with Alt+Enter or within formulas to split text vertically within a cell.
✓Codes 32-126 represent printable ASCII characters; reference an ASCII chart to find the code for any specific character you need.
✓Combine CHAR(9) for tabs and CHAR(10) for line breaks to format multi-line or tabulated output within formulas.

Pro Tips

★Use =CHAR(169) for copyright symbol ©, =CHAR(174) for registered ®, and =CHAR(8482) (with UNICHAR) for trademark ™ in professional documents.
★Nest CHAR in REPT function like =REPT(CHAR(42),10) to create repeated characters (10 asterisks) for visual separators or formatting.
★Chain multiple CHAR functions with concatenation: =CHAR(10)&CHAR(9) for line break followed by tab for precise text layout control.

Troubleshooting

Formula returns blank cell instead of character

Verify the numeric code is between 1-255 and formatted correctly in the formula. Check if your Excel version or regional settings affect character display.

Line break (CHAR 10) not displaying within cell

Enable 'Wrap Text' for the cell: Home > Alignment > Wrap Text or right-click cell > Format Cells > Alignment tab > check 'Wrap text'.

#VALUE! error appears

This indicates an invalid or out-of-range code; use CODE function on a known character to verify the correct numeric value, or consult an ASCII reference table.

Related Excel Formulas

CODE UNICHAR CONCATENATE REPT SUBSTITUTE

Frequently Asked Questions

What is the difference between CHAR and UNICHAR?

CHAR works with ASCII codes 1-255 (basic Latin characters and symbols), while UNICHAR (Excel 2016+) supports Unicode codes up to 1,114,111 for international characters. Use UNICHAR for accented letters, emojis, and non-Latin scripts.

Can I use CHAR to insert emojis?

CHAR (codes 1-255) cannot insert emojis; use UNICHAR with the appropriate Unicode value. For example, =UNICHAR(128512) produces 😀 (grinning face emoji).

How do I find the numeric code for a specific character?

Use the CODE function: =CODE('A') returns 65. Alternatively, reference an ASCII chart online or use the Windows Character Map utility to identify character codes.

What is code 10 used for in CHAR?

CHAR(10) generates a line break character, allowing you to split text into multiple lines within a single cell when combined with 'Wrap Text' formatting.