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).
an empty cell in excel

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

fx icon in excel

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

insert function tab in excel

4. Select TEXT category.

5. Select CHAR function

6. Then select ok.

excel CHAR function

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.

How to use CHAR function in excel

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:

How Find the ASCII Character of any number between (33-122):
=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

How to insert line break between two words (apple-orange):
=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!

Errors in CHAR  function
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.

Leave a Reply

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