## How to use the CHAR function

*Article updated on March 29, 2018*

Use CHAR function to convert a number to the corresponding character. This is determined by your computers character set.

Windows | ANSI |

Macintosh | Macintosh character set |

### Excel Function Syntax

CHAR(*text*)

### Arguments

text |
Required. The number for which you want the corresponding character. |

### Comments

Number 65 to 90 correspond to A to Z.

Number 97 to 122 correspond to a to z.

### Articles with the 'CHAR' Function

The following 4 articles have formulas that contain the CHAR function.

Quickly jump to last row in a data set using excel hyperlink function

Today I´ll show you how to create a useful hyperlink in excel. If you click the link it will take […]Quickly select a data set or an excel defined table [HYPERLINK]

If you often copy data sets or tables, the following technique might be interesting! The animated gif shows two hyperlinks, […]How to create random numbers, text strings, dates and time values

In excel the RAND() function returns a number greater than or equal to 0 (zero) and less than 1. Combining […]### Functions in 'Text'

The CHAR function function is one of many functions in the 'Text' category.