Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Windows SharePoint Services
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Technology Information
Help and How-to
Training
Templates
Related Products and Technologies
Support and Feedback
Technical Resources
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.
Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
CHAR function
 

Returns the character specified by a number. Use CHAR to translate code page numbers you might get from files on other types of computers into characters.

Syntax

CHAR(number)

Number is a number between 1 and 255 specifying which character you want. The character is from the character set used by your computer.

Examples

Formula Description (Result)
=CHAR(65) Displays the 65 character in the set (A)
=CHAR(33) Displays the 33 character in the set (!)
See Also
advertisement
Printer-Friendly VersionPrinter-Friendly Version