September 23, 2023

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) 

Result:

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

=CHAR(B2)
Result: “H”

=CHAR(B3)
Result: “-”

=CHAR(B4)
Result: “m”

=CHAR(B5)
Result: “}”

READ:  How to use the Excel RIGHT function

Leave a Reply

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