Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
  - ABS
  - ACCRINT
  - ACCRINTM
  - ACOS
  - ACOSH
  - ACOT
  - ACOTH
  - ADDRESS
  - AGGREGATE
  - AMORDEGRC
  - AMORLINC
  - ANCHORARRAY
  - AND
  - ARABIC
  - AREAS
  - AREASPARKLINE
  - ARRAYTOTEXT
  - ASC
  - ASIN
  - ASINH
  - ATAN
  - ATAN2
  - ATANH
  - AVEDEV
  - AVERAGE
  - AVERAGEA
  - AVERAGEIF
  - AVERAGEIFS
  - BAHTTEXT
  - BASE
  - BESSELI
  - BESSELJ
  - BESSELK
  - BESSELY
  - BETA.DIST
  - BETA.INV
  - BETADIST
  - BETAINV
  - BIN2DEC
  - BIN2HEX
  - BIN2OCT
  - BINOM.DIST
  - BINOM.DIST.RANGE
  - BINOM.INV
  - BINOMDIST
  - BITAND
  - BITLSHIFT
  - BITOR
  - BITRSHIFT
  - BITXOR
  - BOXPLOTSPARKLINE
  - BULLETSPARKLINE
  - BYCOL
  - BYROW
  - CASCADESPARKLINE
  - CEILING
  - CEILING.MATH
  - CEILING.PRECISE
  - CELL
  - CHAR
  - CHIDIST
  - CHIINV
  - CHISQ.DIST
  - CHISQ.DIST.RT
  - CHISQ.INV
  - CHISQ.INV.RT
  - CHISQ.TEST
  - CHITEST
  - CHOOSE
  - CHOOSECOLS
  - CHOOSEROWS
  - CLEAN
  - CODE
  - COLUMN
  - COLUMNS
  - COLUMNSPARKLINE
  - COMBIN
  - COMBINA
  - COMPLEX
  - CONCAT
  - CONCATENATE
  - CONFIDENCE
  - CONFIDENCE.NORM
  - CONFIDENCE.T
  - CONVERT
  - CORREL
  - COS
  - COSH
  - COT
  - COTH
  - COUNT
  - COUNTA
  - COUNTBLANK
  - COUNTIF
  - COUNTIFS
  - COUPDAYBS
  - COUPDAYS
  - COUPDAYSNC
  - COUPNCD
  - COUPNUM
  - COUPPCD
  - COVAR
  - COVARIANCE.P
  - COVARIANCE.S
  - CRITBINOM
  - CSC
  - CSCH
  - CUMIPMT
  - CUMPRINC
- Functions D to G
- Functions H to L
- Functions M to Q
- Functions R to S
- Functions T to Z

CHAR

This function returns the character specified by a number.

Syntax

CHAR(value)

Arguments

For the argument, use a number between 1 and 255 specifying which character you want from the Windows character set (ANSI).

Data Types

Accepts numeric data. Returns string data.

Examples

CHAR(B2) CHAR(R2C2) CHAR(66) gives the result B CHAR(218) gives the result Ú

Version Available

This function is available in product version 1.0 or later.