Microsoft Excel Text Functions are useful to deal with textual data. In this article, we will discuss a few of the Text functions.
ASC function
This function returns the ASCII text (single-byte characters) from the given text. The given text may contain double-byte characters; then the double-byte characters will convert 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, the 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 within the accepted range. If you give a number that 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 an 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 Excel functions more in future Articles.
🙂 Sahida