Text Functions - 'C'

CHAR- returns the character value of a number
--------------------------------------------------------
Ex.  =Char(65)  returns A
       =Char(123) returns {
Note:  user function CODE to return numeric value of a character

CLEAN - removes all non printable characters
--------------------------------------------------------
Ex:. =Clean(var) returns all printable characters in variable var

CODE- returns numeric value of a character (or first character in a string)
--------------------------------------------------------
Ex: =CODE("A") returns 65
     =CODE("AB") returns 65 (65 if code for A)

CONCATENATE  - joins two or more strings
--------------------------------------------------------
Ex:  =CONCATENATE("hello","boy") returns "helloboy"
       =CONCATENATE("it","is","a","nice","weather") returns "itisaniceweather"