June 18, 2021

How to use CHAR Function in Excel?

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:

Excel CHAR Function 1 - How to use CHAR Function in Excel?

Syntax: =CHAR(B2) 


Excel CHAR Function - How to use CHAR Function in Excel?

Result: “H”

Result: “-”

Result: “m”

Result: “}”

READ:  How to use sumproduct in excel

Leave a Reply

Your email address will not be published. Required fields are marked *