Chr()

Working with Formulas > Functions Used in Formulas > Text Functions > Chr()

CHR() is used to convert numeric ASCII character codes to alphabetic and special characters.  It is often useful when building a string and needing to include non-standard characters such as a tab or return break.  A list of some useful ASCII codes can be found at this website, but there are many others on the Web.

Function Format

CHR(number) 

Return Value

CHR() returns a character string 

Examples

CHR(50) = "2"

CHR(80) = "P"

CHR(112) = "p"

CHR(123) = "{"

CHR(9) = "  " (tab)

CHR(13) = "" (carriage return)