Unit 4.  Formulas and Functions (IV)

 Text functions

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 Exercises about text functions .
 Pag. 4.4

 Legal warning: Authorised on-line use only. It is not allowed the use of these courses in companies or private teaching centres.