CHAR function in Excel, returns the character specified by the code number

If looking for information about CHAR function in Excel, returns the character specified by the code number. The following article will provide you useful information about this Excel function Taimienphi.vn.

Character Encoding

Character Encoding is used on users’ computers, depending on the operating system they are using.

Windows uses the ANSI character set, while Mac OS uses the Macintosh character set, so the characters returned by the Char function in Excel for specific code numbers may differ in different operating system environments. .

Description of the CHAR function in Excel, returns the character specified by the code number

The CHAR function in Excel returns characters related to the provided character set (from 1 to 255).

Note that the character set may be different on different operating systems, so for some specific functions, the Char function may return different results on computers running different operating systems.

The syntax for the Char function in Excel is:

CHAR (number)

Inside:

The number argument is an integer between 1 and 255.

For example, the Char function in Excel returns the character specified by the code number

Example 1

The following worksheet illustrates the Char function in Excel used to return characters related to 4 different number of characters.

Note the results returned below which belong to the ANSI character set (used on Windows operating systems).

Recipe:

Results returned:

Example 2

The Char function in Excel is also used to insert line breaks into text. This is illustrated in the example below. Note that in the ANSI character set, line breaks are associated with the character set 10:

Recipe:

Results returned:

Note in the example above, to display results with line breaks, you must ensure Text Wrapping is enabled.

Added ways to activate Text Wrapping

The easiest way to activate Text Wrapping is to use the Wrap Text button in the group Alignment in Home tab on the Excel Ribbon as shown below.

Common errors with the Char function in Excel

If Char Excel returns an error message, it may be a #VALUE! Error.

Error #VALUE! : This error occurs if:

– The argument is provided with 255.

– The supplied argument is not recognized as a numeric value.

Above Taimienphi.vn has just provided you with useful information about the CHAR function in Excel, returns the character identified by the code number. The following articles Taimienphi.vn will introduce you to some other Excel functions. In addition, readers can refer to some other articles on Taimienphi.vn such as the common calculation function in excel for statistics and faster processing of numbers.

https://thuthuat.taimienphi.vn/ham-char-rong-excel-34302n.aspx
Referring to the calculation function, we can not ignore the SUMIF function, this is the conditional sum function, users often use the SUMIF function in the article to request the sum of a column with a given condition.