Excel Formulas – CHAR Function to Find ANSI Character

CHAR Function

Text FORMULA – CHAR Function

[ResponsiveRect]

What Does It Do?
This function converts a normal number to the character it represent in the ANSI
character set used by Windows.

Syntax
=CHAR(Number)

The Number must be between 1 and 255.

Formatting
The result will be a character with no special formatting.

Example
The following is a list of all 255 numbers and the characters they represent.
Note that most Windows based program may not display some of the special characters, these will be displayed as a small box.

ANSI Values Table for CHAR Function

Note

Number 32 does not show as it is the SPACEBAR character.

[ResponsiveRect]

GenronTech Header-Cartoon

Advanced Excel Formulas Index

  1. Jump To Advance Excel Formulas Main Menu
  2. Jump To Database Function
  3. Jump To Date and Time Function
  4. Jump To Financial Function
  5. Jump To Informational Function
  6. Jump to Logical Function
  7. Jump To Math Function
  8. Jump to Statistical Function
  9. Jump To Engineering Function
  10. Jump To Text Function

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top