Function Char()

Char()

This function returns the character for the given numeric code. In Excel ther are 255 characters alloted to these numeric codes.

Syntax:

= Char (Numeric Code)

Numeric Code = is the numeric code, or reference to a cell that contains the numeric code, for which the corresponding character is to be retrieved

Example:

• = Char (69) - result will be - E
• = Char (77) - result will be - M
  
• = Char (101) - result will be - e
  
• = Char (109) - result will be - m
  
• = Char (65) - result will be - A
  
• = Char (97) - result will be - a
• = Char (64) - result will be - @
  
• = Char (128) - result will be - €
  
• = Char (174) - result will be - ®
  

Excel Matic Tip:

In Excel there are 255 numeric codes for the characters and symbols. To know which character is asociated with which code do this:

• In cell A1 write 1 and in cell A2 write 2
  
• Select the rangeA1:A2
  
• Now keep the mouse cursor on right-bottom edge of the selection. The cursor will now turn into cross shape (i.e. - '+')
  
• Now press the left mouse button and drag down the range with the left button still pressed
  
• This will auto-fill the range with consecutive numbers
  
• Drag till 255 and stop there
  
• Now in cell B1 type this formula:
  
  =Char(A1)

• Again drag this range down as done previously till B255

You will see that in the B column all the codes will populate for corresponding characters in column A

Share on Facebook Share on Twitter Share on Google Plus

About Dhakkanz

This is a short description in the author block about the author. You edit it by entering text in the "Biographical Info" field in the user admin panel.