CHAR formula in Excel with examples

The CHAR function in Excel is a handy tool for translating ASCII code page numbers into actual characters. Let’s explore how it works and provide some examples:

1. Syntax:

   • The CHAR function has the following structure:

     =CHAR(number)
     

   • number: An integer between 1 and 255 representing the character code.

2. Examples:

   • To get the letter “A”, use:

     =CHAR(65)   // Result: "A"
     

   • For an exclamation mark “!”, use:

     =CHAR(33)   // Result: "!"
     

   • To create a dollar sign “$”, use:

     =CHAR(36)
     

   • And for a semicolon “;”, use:

     =CHAR(59)
     

Remember, the CHAR function lets you work with specific characters that might be awkward to type directly in your formulas!