Wednesday 11 September 2019

Char Function in Excel

The Char function returns the character specified by the code number from the character set for your computer. The character set varies from the operating system to the operating system. The main purpose of char function is that get a character from the number.


Syntax of the Char function is

=CHAR(number)


In the example given above, you can see that every number (A number range from 1 to 255 )has been converted into a character with the help of char function. When we want to convert a number more than 255 its gives an #VALUE error.

No comments:

Post a Comment