# CHAR function in Excel

> CHAR returns the character for a code number.

Source: https://spreadsheetpractice.com/functions/char · Updated October 28, 2026 · Formulas and results on this page were run by the Spreadsheet Practice formula engine on November 20, 2026

## Quick answer

- **What it does:** CHAR returns the character for a code number.
- **Syntax:** `=CHAR(number)`
- **Most common use:** `=A2&CHAR(10)&B2` returns 12 Oak St
Duluth, MN (A two-line address; turn on Wrap Text to see the break)
- **Available in:** Every current version
- **Category:** [Text functions](https://spreadsheetpractice.com/functions/category/text)
- **Returns:** A single character.

## What it does

CHAR returns the character for a code number. Its everyday use is CHAR(10), the line break, which lets a formula put text on two lines. It also produces characters that are awkward to type in a formula, like the double quote.

## Syntax

`=CHAR(number)`

| Argument | Required? | What it is |
|---|---|---|
| `number` | Required | A code from 1 to 255. 10 is a line break, 9 a tab and 34 a double quote. |

## Examples

Each result was calculated by running the formula on the sample sheet.

| Cell | Formula | Result | What it shows |
|---|---|---|---|
| D2 | `=A2&CHAR(10)&B2` | 12 Oak St Duluth, MN | A two-line address; turn on Wrap Text to see the break |
| D3 | `=CHAR(34)&C3&CHAR(34)` | "Raj" | A name wrapped in double quotes |
| D4 | `=CHAR(65+2)` | C | Codes 65 to 90 are the capital letters, so 67 is C |

### The sample sheet

Every formula above runs on this data:

|  | A | B | C | D |
|---|---|---|---|---|
| 1 | Street | City | Name | Result |
| 2 | 12 Oak St | Duluth, MN | Maya | 12 Oak St Duluth, MN |
| 3 | 88 Pine Ave | Fargo, ND | Raj | "Raj" |
| 4 | 5 Elm Rd | Rochester, MN | Lee | C |

## Common mistakes

| What you see | Why, and how to fix it |
|---|---|
| The line break doesn't show | The cell needs Wrap Text turned on (Home > Wrap Text), or the break stays invisible. |
| Different characters on a Mac | Codes above 127 come from the operating system's character set, so they can differ between Windows and Mac. Stick to codes below 128, or use UNICHAR for a specific Unicode character. |

## Tips

- Use CHAR(10) as the delimiter in TEXTJOIN to stack a list in one cell, one item per line.

## Related functions

- [CODE](https://spreadsheetpractice.com/functions/code): CODE returns the numeric code of the first character in a text string.
- [CLEAN](https://spreadsheetpractice.com/functions/clean): CLEAN removes non-printing characters, such as line breaks and tabs, from text.
- [SUBSTITUTE](https://spreadsheetpractice.com/functions/substitute): SUBSTITUTE replaces specific text with new text everywhere it appears, or only at the occurrence you choose.

## Questions

### How do I add a line break in an Excel formula?

Join with CHAR(10): =A2&CHAR(10)&B2, then turn on Wrap Text for the cell. When typing directly in a cell, press Alt+Enter instead.

### What is CHAR(34) in Excel?

The double quote character. It's an easy way to put quotes inside a formula's text without doubling them up.

## Practice

A graded CHAR exercise ("Two-line labels") is on [the CHAR page](https://spreadsheetpractice.com/functions/char). It is checked instantly, then re-checked on changed data.

---

Spreadsheet Practice (https://spreadsheetpractice.com) teaches spreadsheet formulas by practice: every exercise is graded in a live grid and re-checked on changed data.
