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 Google Plus

About Rishie Khurana

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.
    Blogger Comment
    Facebook Comment

0 comments:

Post a Comment

Monday, June 8, 2009

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

Function Char()SocialTwist Tell-a-Friend

0 comments:

Post a Comment