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.
© aulaClic. All rights reserved. Reproduction in any form whatsoever is prohibited.
November-2005.