Spreadsheets are designed to be used with figures. But Excel also has a number of specific functions for the manipualtion of texts.
These are all the text functions offered by Excel.
| Function |
Description |
See Details |
| CHAR(number) |
Returns
the character specified by the number |
 |
| CODE(text) | Returns
the ASCII code of the first character of
the text |
|
| CONCATENATE(text1;text2,...;textN) | Returns
a chain of characters with the union |
|
| FIXED(number;decimals;no_commas) | Rounds
(up or down*) a figure passed as parametre |
|
| RIGHT(text;num_chars) | Returns
the number of characters specified |
|
| SEARCH(find_text;within_text;start_num) | Returns
the initial position of the text searched |
|
| TRIM(text) | Removes
all spaces between words except for single spaces between words |
|
| MID(text;start_num;num_chars) | Returns
the characters indicated in a chain |
|
| FIND(find_text;within_text;start_num) | Finds
a chain inside a text |
|
| EXACT(text1;text2) | Returns
a logical value (true/false). Check whether two texts are strictly
the same |
|
| LEFT(text;num_chars) | Returns
the number of characters specified |
|
| LEN(text) | Returns
the length of the text |
|
| CLEAN(text) | Cleans
the text, gets rid of characters that can't be printed |
|
| UPPER(text) | Converts
into capital letters |
|
| LOWER(text) | Converts
into small letters (lower case) |
|
| DOLLAR(number;decimals) | Converts
into currency |
|
| PROPER(text) | Converts
into capital the first letter of a text |
|
| REPLACE(old_text;start_num;num_chars;new_text) | Replaces
part of a text chain for another |
|
| REPT(text;number_times) | Repeats
the text |
|
| SUBSTITUTE(text;old_text;new_text;instance_num) | Substitutes
a text for another |
|
| T(value) | Checks
up that the value is text |
|
| TEXT(value;format_text) | Converts
a value in text |
|
| BAHTTEXT(number) | Converts
a number in Thai text (Baht) |
|
| VALUE(text) | Converts
a text in a number |
|
You
can practise some of the above functions in 
