CHAR function

Excel’s CHAR function returns a character based on the ASCII code. It is a simple yet useful function.

Syntax

CHAR(number)

Arguments

numberThe ASCII code of the character you want to retrieve. Must be a number between 1 and 255.

How to use

Here are some examples of how to use the CHAR function:

Remember that the number must be between 1 and 255, as it corresponds to valid ASCII codes.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.