CHAR

Converts a number into a character according to the current code table. The number can be a two-digit or three-digit integer number.

大於 127 的代碼會視系統的字元對映而定 (例如 iso-8859-1、iso-8859-2、Windows-1252、Windows-1250),因此無法移植。

Syntax

CHAR(Number)

Number is a number between 1 and 255 representing the code value for the character.

Example

=CHAR(100) returns the character d.

="abc" & CHAR(10) & "def" inserts a newline character into the string.

Please support us!