CHAR function comes under the TEXT category in Excel.
CHAR function returns the character specified by an ANSI CHARACTER from 1 to 255.
ANSI, while the development of computing system defined the characters such as a to z, A TO Z, !,@ and so many other symbols with the ANSI CODE ranging from 1 to 255.
This function is specifically used if we need to convert the character set from one system to other or we can use if we need to use any character.
PURPOSE OF CHAR IN EXCEL
CHAR FUNCTION returns the character specified by a number.(ANSI CODE)(1-255)
PREREQUISITES TO LEARN CHAR
THERE ARE A FEW PREREQUISITES WHICH WILL ENABLE YOU TO UNDERSTAND THIS FUNCTION IN A BETTER WAY.
- Basic understanding of how to use a formula or function.
- Basic understanding of rows and columns in Excel.
- Some information about the financial terms is an advantage for the use of such formulas.
- Of course, Excel software.
The Syntax for the function is
NUMBER is any number CORRESPONDING TO A CHARACTER.(1 TO 255)
EXAMPLE:CHAR IN EXCEL
Let us check the different codes from 1 to 255.
STEPS TO USE CHAR
WHAT ARE ANSI CHARACTERS
OTHER WAYS TO REACH THIS ARTICLE
CHAR FUNCTION, CONVERT NUMBER TO SYMBOL,INSERT SYMBOL DIRECTLY, ANSI CHARACTER INSERTION