Microsoft Excel – Text Functions – ASC, CHAR, UNICHAR and UNICODE formulas

Microsoft Excel Text Functions are useful to deal with the text data. In this Article we will discuss few of the Text functions.

ASC function

This function returns the ASCII text (single byte characters) from the given text. The give text may contain double byte characters; then the double byte characters will converts to single byte characters.

If the given text doesn’t contains any double byte characters; that means, if the given text contains only ASCII characters, this function will not convert the text and returns the text as it is.

CHAR function

Operating Systems use different character sets to display the characters. This function supports the single byte character set. For example, ANSI character set in Windows Operating System.

This function returns the character value for the given number (usually it will be between 1 and 255).  The number must be with in the accepted range. If you give the number which is not in the range, this function returns #VALUE! Error.

UNICHAR function

CHAR function returns the single byte character whereas UNICHAR function returns the Unicode character from the given Unicode number. Like CHAR function this function also returns #VALUE! Error if you pass invalid Unicode number. For example, if you pass the number 0; which doesn’t represent any Unicode character; this function returns #VALUE! Error.

UNICODE function

This function returns the Unicode number corresponding to the first character from the given text. Like other functions discussed above, UNICODE function returns the #VALUE! Error if you pass invalid text.

We will discuss more on Excel in future Articles.

🙂 Sahida

Microsoft Excel – Text Functions – ASC, CHAR, UNICHAR and UNICODE formulas

Leave a Reply

Your email address will not be published.

Scroll to top