Skip to main content

How to Use the CHAR Function in Excel for Mac

Joshua earned an MBA from USF and writes mostly about software and technology.

how-to-use-the-char-function-in-excel-for-mac

The Purpose of the CHAR Function

The CHAR function gives an Excel user the ability to show the following an abundance of characters. The function uses description numbers that identify these characters to display them. Characters from the following character types can be used in this function.

ASCII (32-126) characters - Printable Characters

ANSI (128-159) characters - Control Characters

ANSI (160-255) characters

The CHAR Function Syntax

The CHAR function needs to be inputted into a cell like a formula to work properly. To manually add this function the following steps need to be taken:

  1. A cell needs to click type "=CHAR(".
  2. After the open parenthesis, a number needs to be added followed by a closing parenthesis.
  3. After the formula is created it can be entered into the cell.

Below in bold is the syntax of the CHAR function.

=CHAR(Number)

Number - As stated above, this function will display characters from the 3 character types. The number used in this formula is the description number of a character.

To display all available characters for reference, create a list of numbers from 32 to 255. Enter the CHAR function and reference the cell with the 32. This character will be a space.

Make sure the cell with the formula is selected and double-click on the square in the corner of the cell to get the symbols related to the numbered cells to appear. You may also find references to the characters here.

how-to-use-the-char-function-in-excel-for-mac

Inserting the CHAR Function

The CHAR function can be inserted into a cell by first selecting the cell, then clicking in the formulas tab. Next, click on the text button and select CHAR from the list of functions.

how-to-use-the-char-function-in-excel-for-mac

Once the formula builder appears, numbers can be added to see the results at the bottom of this sidebar. This formula builder can be a great help to reference characters.

When the correct character is found the done button can be clicked for the function to be entered into the cell.

how-to-use-the-char-function-in-excel-for-mac

This content is accurate and true to the best of the author’s knowledge and is not meant to substitute for formal and individualized advice from a qualified professional.

© 2022 Joshua Crowder