# Learn How to Use Microsoft Excel CHAR Function

Written by | 0 Comments | 797 Views

In this article, you will learn how to use a Microsoft Excel CHAR function and its prime function in Microsoft Excel. You will also get to know the Microsoft Excel CHAR function return value and syntax with the help of some examples.

## 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.