Leading the way in Microsoft Office Development
 Home|Excel|Word|PowerPoint|Consultancy|Feedback|Contact 
 Microsoft Excel > Functions > Text > CHAR
 

CHAR(number)

 
 Returns the character with the corresponding ANSI number.

 numberThe number specifying which character you want between 1 and 255.

 REMARKS
 
  		• The character corresponding to an ANSI number is the inverse of the CODE() function.
     
  		• The "number" argument can be with or without leading zeros.
     
  		• Every computer use numeric codes to represent characters, the most prevalent system is the ASCII.
     
  		• For a full list of all the ASCII String Codes, please refer to the String Table page.
     
  		• If you are using a Macintosh then the character set is different to Windows.

     EXAMPLES
     
     A
    1=CHAR(65) = A
    2=CHAR("00065") = A
    3=CHAR(70) = F
    4=CHAR(125) = }
    5=CHAR(65+26) = [
    6=CHAR(CODE("A")) = A
    7=CHAR(CODE("A")+32) = a
    8=CHAR(-10) = #VALUE!
    9=CHAR(40000) = #VALUE!
    10=CHAR("some text") = #VALUE!
    		 
     Functions - C | Index - C | Text Manipulation | Office Online 

     Copyright © 2004-2007 Better Solutions Limited. All Rights Reserved.Top