Excel CHAR Function

What is the CHAR function in Excel?

The CHAR function is one of the TEXT functions of Excel.

It Returns the character specified by the code number from the character set for your computer.

We can find this function in TEXT category of insert function Tab.

How to use CHAR function in excel

1. Click on an empty cell (like F5).

2. Click on the fx icon (or press shift+F3).

3. In the insert function tab you will see all functions.

4. Select TEXT category.

5. Select CHAR function

6. Then select ok.

7. In function arguments Tab you will see CHAR function.

8. Number section is a number between 1 and 255 specifying which character you want.

9. You will see the results in formula result section.

Examples of CHAR function in Excel

Example 1:

How Find the ASCII Character of any number between (33-122):

We can Find the ASCII Character of any number between (33-122) with CHAR function:

=CHAR(33)----->>>>answer is  !
=CHAR(48)----->>>>answer is  0
=CHAR(63)----->>>>answer is  ?
=CHAR(78)----->>>>answer is  N
=CHAR(93)----->>>>answer is  ]

Example 2:

How to insert line break between two words (apple-orange):

you can use CHAR(10) to insert a line break. Text wrap must be enabled to see the line break take effect

=CHAR(10)----->>>>answer is  linebreak

What is the purpose of CHAR function?

It Returns the character specified by the code number from the character set for your computer.

What is the Return value  of CHAR function?

It just returns the text.

CHAR (number)=text

How many arguments does CHAR function have?

CHAR (number)

CHAR function has 1 argument.

• Number section is a number between 1 and 255 specifying which character you want.

Which version of excel supports CHAR function?

This function is available for all excel versions (2003-2019)

Errors in CHAR function

If number is out of range, CHAR returns #VALUE!

If number is not numeric, CHAR returns #VALUE!

CHAR (256)----->>>>answer is  #VALUE!

What is reverse function of CHAR ?

Code and Char functions are reverses of each other.

=CHAR(33)----->>>>answer is  !
=Code(!)----->>>>answer is  33

CHAR related functions

• UNICHAR function
• Use CODE function to return a numeric code for the first character in a text string, in the character set used by your computer.
• UNICODE function
• Use BAHTTEXT function to Convert a number to text.

Related posts:

Keyboard Shortcut to cut a cell value Excel TEXTJOIN Function Excel FORMULATEXT Function Excel TEXT Function