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!