Excel Guides

Converting Codes to Characters in Excel

When working with text in Excel, it is sometimes necessary to convert code values to their corresponding characters. For example, the code for a space is 32, the code for an exclamation point is 33, and the code for a dollar sign is 36. If you have a column of cells that contain these code values and you want to convert them to their corresponding characters, you can do so using the CHAR function.

The CHAR function takes a single argument that is the code value of the character you want to return. For example, to return the character corresponding to the code value 32 (a space), you would use the following formula:

=CHAR(32)

To return the character corresponding to the code value 33 (an exclamation point), you would use the following formula:

=CHAR(33)

To return the character corresponding to the code value 36 (a dollar sign), you would use the following formula:

=CHAR(36)

You can also use the CHAR function to return multiple characters by concatenating multiple CHAR functions together. For example, to return a space followed by an exclamation point, you would use the following formula:

=CHAR(32)&CHAR(33)

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.