CHAR Function in Apple Numbers: Syntax, Examples, and Troubleshooting

Use CHAR to build alphabetic labels from calculated codes, examine imported numeric character identifiers, or produce text symbols without typing the symbol. It is not a tool for creating arbitrary control characters, and it is not a universal Unicode-character generator. For instance, Apple’s documented CHAR input ceiling prevents using a single CHAR argument for Unicode code points above 65,535. In particular, do not assume an emoji can be generated using CHAR(128512) in Numbers.

=CHAR(code-number)

Component: code-number

Required?
Yes

Apple’s rule
Numeric decimal character code

What to check
Valid documented range 32–65535; exclude 127–159 and illegal characters.

Component: Fractional portion

Required?
Not a separate argument

Apple’s rule
Ignored

What to check
Apple’s own 98.6 example yields b.

Component: Default value

Required?
None documented

Apple’s rule
One numeric input is expected

What to check
Do not omit the argument or supply a second one.

Evidence: Apple CHAR — Functions Help 15.4. CHAR returns text, not a numeric cell-code. Different fonts/devices may display valid Unicode characters differently. Apple explicitly warns that some codes do not correspond to printable characters.

Reproducible worksheet: code-to-character lab

Create one Numbers table named Characters Lab. Make column A a numeric input, and enter =CHAR(A2) in B2, then fill down. To avoid any locale-specific ambiguity, enter whole-number codes for the first four rows.

Row: 2

A: decimal code
65

B formula
=CHAR(A2)

Expected B result
A

Validation basis
Unicode code point calculation; native Numbers not tested

Row: 3

A: decimal code
90

B formula
=CHAR(A3)

Expected B result
Z

Validation basis
Independent Unicode mapping

Row: 4

A: decimal code
98

B formula
=CHAR(A4)

Expected B result
b

Validation basis
Official Apple 98.6 example plus mapping

Row: 5

A: decimal code
19977

B formula
=CHAR(A5)

Expected B result
三

Validation basis
Independent Unicode mapping of U+4E09; native not tested

Now put 98.6 in A6 in an English-decimal document and enter =CHAR(A6) in B6. Apple explicitly documents b. In a comma-decimal region, enter 98,6 instead; the decimal format differs, not the underlying number. Do not interpret the comma in 98,6 as two function arguments.

For a compact literal formula not requiring input cells, use =CHAR(65)&CHAR(66)&CHAR(67). Its expected string is ABC by combining the separately mapped characters with Numbers’ text-concatenation operator. This composition is independently reasoned, not observed in Numbers.

Advanced: generate alphabet letters from row data

For each integer n from 0 to 25 in A2:A27, use =CHAR(65+A2) in B2 and copy the formula down. The expected output runs from A to Z because these are the consecutive Unicode codes 65–90. To guard against out-of-range letter indices, put this in C2:

=IF(AND(A2>=0,A2<=25),CHAR(65+A2),"Outside A–Z")

Expected for A2=0: A; A2=25: Z; A2=26: Outside A–Z. This checks the intended alphabet range only, not every Unicode legality rule. It assumes a numeric input and uses the documented logic-function syntax. No native execution was performed.

Potential error cases: Invalid range, control and illegal codes are documented restrictions, but the exact displayed error text for each case was not tested; no exact application error code is asserted here.

Apple’s Functions overview describes English examples with comma argument separators. When your document uses a comma decimal separator, multi-argument functions use a semicolon (;) instead. This function has only one argument, so it has no argument-separator issue; however, 98.6 becomes 98,6 as a decimal input in such a locale. A2 is a cell in the same table as B2; cross-table references may need a table/sheet qualifier (Apple’s reference guidance).

Excel is materially different: Microsoft’s Excel CHAR help specifies a code-page-based CHAR(number) in the range 1–255, with platform-dependent character sets. Thus common ASCII letters agree, but extending Apple Numbers’ documented 65,535 ceiling to Excel CHAR is incorrect. Microsoft Excel also has Unicode-oriented alternatives; this guide does not claim identical implementations. Google Sheets CHAR describes a Unicode-table mapping, but its function documentation does not override Apple’s validity exclusions or verify equivalent behaviour for every code.

Apple CODE performs the reverse direction for the first character of text. Apple CLEAN removes certain invisible codes from existing text, and does not expand CHAR’s permitted range.

Sources checked 2026-10-12: Official Apple CHAR; Apple CODE; Apple Functions overview; Apple cell references; Microsoft Excel CHAR; Google Sheets CHAR.

• CODE — continue with a related Apple Numbers calculation.
• CLEAN — continue with a related Apple Numbers calculation.
• T — continue with a related Apple Numbers calculation.
• REPT — continue with a related Apple Numbers calculation.
• FIXED — continue with a related Apple Numbers calculation.

For a software-specific comparison: Microsoft Excel CHAR, Google Sheets CHAR, LibreOffice Calc CHAR. A shared name does not establish identical argument, error or version behaviour.

The linked official function documentation was reviewed on October 12, 2026. Apple’s Formulas and Functions Help 15.4 identifies the documentation edition, not a minimum Numbers release or a guarantee of historical platform parity. Selected worked examples were checked using independent mathematical or text-processing models; results are expected values, not observations from the spreadsheet application. Native Apple Numbers execution was not performed. Undocumented coercion, exact error messages and platform-specific behaviour remain unverified.

View reproducible example inputs and independent check results. This record is not a native spreadsheet test log.