This function coverts a normal number to the character it represents in the ANSI
character set.
Syntax:
=CHAR (number)
Parameter list:
number – A number between 1 and 255.
Example : When you need to define characters in formulae or functions that are difficult or impossible to enter directly, CHAR can be beneficial. For example, on Windows, you can use CHAR(10) to insert a line break into a calculation, whereas on Mac, you may use CHAR(13).
Ask Your Query