Learn How to Use Microsoft Excel CHAR Function

Microsoft Excel CHAR Function

The prime purpose of the CHAR function is to get a character from a number. That means the Microsoft Excel CHAR function returns the character when provided a valid character code. The CHAR function can be utilized to specify characters that are hard to enter into a formula. Let's say, for example, CHAR(10) will return the line break in Windows, while CHAR(13) will return a line break in Macintosh.

CHAR Function Return Value

It will return a single character specified by the number.

CHAR Function Syntax

= CHAR (number)

Where the arguments:

• number: It is a number between 1 to 255.

How to Use Microsoft Excel CHAR Function?

You can use the CHAR function to translate code page numbers into actual characters. CHAR function is also useful when you are required to specify characters in functions or formulas which are very difficult to type or awkward. As we mentioned earlier, you can always use CHAR(10) for a line break in Windows, while CHAR(13) for a line break in Macintosh. The characters returned by the CHAR function are according to the character set used by your specific computer. 

Check out the list of all other articles:

• Learn How to Get nth Match in Microsoft Excel
• Learn How to Find Missing Values in Microsoft Excel
• Learn How to Get nth Smallest Value With Criteria in Microsoft Excel
• Learn How to Sort by Text Length in Microsoft Excel
• Learn How to Sort by Two Columns in Microsoft Excel
• Learn How to Sort by Random in Microsoft Excel
• Learn How to Sort by One Column in Microsoft Excel
• Learn How to Sort by Custom List in Microsoft Excel