The CHAR Function in Excel | Char

The Excel CHAR function is used for converting a number code into its character. Each character in excel has number code. To convert a code into its equivalent text we use CHAR function.
Syntax

=CHAR(number)

Number: CHAR function only has one parameter and that is the number that you want to convert into text.
Example

If you supply 65 as a parameter to char function it will return A.

=CHAR(65)

If write below formula it will return one.

=CHAR(49)

Actually CHAR function sees any number as ASCII code. Each ASCII code has its equivalent number or character.

Its fun to see which code returns what character. Here I used rand between to generate random number between 1 and 255 and then applied CHAR function to each number. See what I got. ASCII CODES are 1 to 255 only. Any number above 255 will return #VALUE error.
247
Do you know what is how can you Insert a Line Break using Formula? Excel CHAR function can help you there. The code for new line is 10 in Microsoft and 13 in excel for MAC.

The counter function of CHAR function is CODE function. The CODE function returns the ASCII code of any character supplied to CODE function.

So Yeah guys, this how CHAR function works in excel. Let me know if you have any specific question regarding this function. The comments section is all yours. I will be happy to help you.

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube