The CHAR function takes a number between 1 and 255 to return the corresponding character from the ANSI windows character set (or Macintosh character set). It's a simple function that is probably obscure to the typical user, but handy when you want to display a special character.

CHAR takes 1 required argument and no optional arguments:

Syntax: CHAR(number)

Using the CHAR function:
The arguments for the CHAR function are:
Argument Required? Description
number Required A number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.
Illustrating the full ANSI character set using the CHAR function:


CHAR is an easy to use function for displaying any character in the character set and is likely an obscure, seldom used function to the average user.
comments powered by Disqus