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:
Syntax: =CHAR(B2)
Result:
=CHAR(B2)
Result: “H”
=CHAR(B3)
Result: “-”
=CHAR(B4)
Result: “m”
=CHAR(B5)
Result: “}”
