Home   Back   Next  

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





Return Value


CHR() returns a character string 





CHR(50) = "2"


CHR(80) = "P"


CHR(112) = "p"


CHR(123) = "{"


CHR(9) = "  " (tab)


CHR(13) = "" (carriage return)