EXCEL CHAR FUNCTION

This function coverts a normal number to the character it represents in the ANSI

character set.

Syntax:

=CHAR (number)

Parameter list:

number – A number between 1 and 255.

Step By Step Guide of CHAR Function

Example : When you need to define characters in formulae or functions that are difficult or impossible to enter directly, CHAR can be beneficial. For example, on Windows, you can use CHAR(10) to insert a line break into a calculation, whereas on Mac, you may use CHAR(13).

Related Functions

HLOOKUP Function

HLOOKUP Function

Explore Now

VLOOKUP Function

VLOOKUP Function

Explore Now

INDEX Function

INDEX Function

Explore Now

MATCH Function

MATCH Function

Explore Now

DATE Function

DATE Function

Explore Now

IF Function

IF Function

Explore Now

OR Function

OR Function

Explore Now

AND Function

AND Function

Explore Now

RANK Function

RANK Function

Explore Now

SUMIF Function

SUMIF Function

Explore Now

XIRR Function

XIRR Function

Explore Now

WORKDAYS Function

WORKDAYS Function

Explore Now