Formulas and Functions

You can use the CHAR function to do the opposite of the CODE function: convert a Â
numeric code into a text character.
Examples
=CODE(”A”) returns 65, the character code for uppercase “A”.
=CODE(”abc”) returns 97 for lowercase “a”.
=CHAR(97) returns “a”.
=CODE(A3) returns 102 for lowercase “f”.
=CODE(”三二一”) returns 19,977, the decimal Unicode value of the rst character.
Related Topics
For related functions and additional information, see:
“CHAR” on page 308
“Listing of Text Functions” on page 306
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
CONCATENATE
The CONCATENATE function joins (concatenates) strings.
CONCATENATE(string, string…)
 string: A string. string is a string value.
 string…:Optionally include one or more additional strings.
Usage Notes
As an alternative to the CONCATENATE function, you can use the & string operator Â
to concatenate strings.
Examples
If cell A1 contains Lorem and cell B1 contains Ipsum, =CONCATENATE(B1, “, “, A1) returns “Ipsum,
Lorem”.
=CONCATENATE(”a”, “b”, “c”) returns “abc”.
=”a”&”b”&”c” returns “abc”.
Related Topics
For related functions and additional information, see:
310 Chapter 11 Text Functions