Excel Text Functions

Special

Excel Functions

2003

Special

Excel Functions

2007

Lesson 10: Excel Spreadsheets Text Functions (24)

In annex 10 you have found a description of all 24 Excel functions in the "Text" category. Below is the list of the 9 most useful ones.

Functions	What it Does
LEFT	Returns the leftmost characters from a text value
LEN	Returns the number of characters in a text string
MID	Returns a specific number of characters from a text string starting at the position you specify
RIGHT	Returns the rightmost characters from a text value
TRIM	Removes spaces from text
FIND	Finds one text value within another (case-sensitive)
REPT	Repeats text a given number of times
TEXT	Formats a number and converts it to text
VALUE	Converts a text argument to a number

In the downloadable tutorial on Excel functions and formulas you will find example of formulas using each of these functions and even many of them assembled in easy and powerful formulas.

Go to the next lesson:
Lesson 11: The Excel Function SUMPRODUCT

See the complete version of this lesson in
The Tutorial on Excel
Functions