HCL TECHNOLOGIES ABOUT US PRODUCTS & SOLUTIONS RESOURCES CONTACT US

Home
Using IBM Connections Docs 2.0 CR3Welcome to the IBM Connections Docs 2.0 CR3 documentation, where you can find information about IBM Docs 2.0 CR3. IBM Docs is a collaborative productivity suite that enables you to work on documents, spreadsheets and presentations together in the cloud.
Using IBM DocsIBM Docs is a new office productivity suite for working on documents, spreadsheets and presentations—together—in the cloud. It provides real-time co-editing, allowing users to work on documents individually or collaboratively. Comment on a document, or even participate in a discussion. All this without the need of desktop software.
Working with spreadsheetsCalculate, analyze, and manage your data. Several categories of functions are available to create formulas to perform complex calculations on your data.
Using formulas in calculationsThis section provides background information on formulas and functions, and organizes the functions in alphabetical order or by category to make it easy to find related functions.
List of functionsUse these functions to create formulas for spreadsheet calculations.
CHAR functionCHAR finds and returns a character in Unicode character map by the number. The number is between 1 and 255.

CHAR function

CHAR finds and returns a character in Unicode character map by the number. The number is between 1 and 255.

Syntax

CHAR(number)

number indicates which character in the Unicode character map is to be returned.

Note: The Unicode character map is different from the Windows™ ANSI character map or the MAC character map, according to the user's client. You cannot refer to the client's character map unless you use a server-side formula calculation.

When number is of [128, 255], the returned characters might be different in IBM® Connections Docs and IBM Symphony® in various locales, because the character maps used in IBM Docs (browser) and Symphony (client-side applications) are different.

Example

=CHAR(82) returns R.

=CHAR(255) returns ÿ.