Learn Excel - Simplify Life with Excel Concepts

## Excel CHAR Function ### How to use the CHAR Function

This Excel tutorial explains how to use the Excel CHAR function with syntax and examples.

### SUMMARY:

The Excel CHAR function use to converts a number into single Character relating to a supplied input number set from 1 to 255.

For example,

• The formula =CHAR(89) would return "Y"
• The formula =CHAR(55) would return "7"

### PURPOSE:

To convert a number into Character.

### RETURN VALUE:

The CHAR function returns single character String text.

=CHAR(number)

### ARGUMENTS:

The CHAR function syntax has the following arguments:

• number: Required. Any number range between from 1 to 255, that you want to convert into character text.

### REMARKS:

• It Converts only number from the range between 1 and 255.
• If the input argument "number" is not numeric, then #VALUE! is returned.
• If the input argument "number" is not from the range between 1 and 255, then #VALUE! is returned.