ASCII Character (CHAR)

Syntax: CHAR(Number)

The CHAR function returns an ASCII character whose number is 0 to 255. For example:

=CHAR(64)

returns the character @.

images

Figure 11-1. Sample result of the CHAR function

The characters displayed on screen may differ depending on the system’s language and display font settings.

Get Beginning OpenOffice Calc: From Setting Up Simple Spreadsheets to Business Forecasting now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.