The Excel CHAR Function returns a character based on its Windows-1252 character number. It’s handy for inserting characters or punctuation into text strings, or for converting codes you might get from other computers into characters.
Syntax: =CHAR (number)
The CHAR function syntax has the following arguments:
- Number (required argument) – This is a number between 1 and 255 specifying which character we want. The character is from the character set used by our computer.
Example: Let’s look at some Excel CHAR function examples and explore how to use the CHAR function as a worksheet function in Microsoft Excel: