### Articles related to excel text functions

**Text Functions**-

**Excel's Text Functions**- Spreadsheets - About.com

**Excel's Text Functions**help you manage the

**text**data in your spreadsheets.

http://spreadsheets.about.com/od/exceltextfunctions/

**Excel**LEFT

**Function**- Spreadsheets - About.com

Sep 21, 2007

**...**The LEFT**function**, one of**Excel's text functions**, is used to remove unwanted characters from the right side of a data entry. This tutorial includes ...http://spreadsheets.about.com/od/excelfunctions/qt/20070921_left.htm

Extract a Substring Using the MID

**Function**in**Excel**- Spreadsheets**Excel's**MID

**function**can be used to extract a substring from a

**text**string containing unwanted characters. This tutorial includes a step by step example of using ...

http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm

Convert Case for

**Text**Data with the**Excel**PROPER**Function**The PROPER

**function**is used to convert**text**data to proper case letters ( combination upper and lower case). A step by step example is included with this tutorial.http://spreadsheets.about.com/od/excelfunctions/qt/8124_proper.htm

Convert

**Text**to Numbers in**Excel**- Spreadsheets - About.comHow to convert

**text**data to numbers in**Excel**using the VALUE**function**. This tutorial contains a step by step example of how to convert**text**data to numbers in ...http://spreadsheets.about.com/od/Text-Functions/ss/2011-05-26-excel-convert-text-to-numbers.htm

**Excel**Formulas and

**Functions**- Spreadsheets - About.com

The IF

**function**has also been combined with other popular**Excel functions**to ...**Excel's Text Functions**help you manage the**text**data in your spreadsheets.http://spreadsheets.about.com/od/excelformulas/u/formulas_functions_user_path.htm

Entering

**Text**with the**Excel**IF**Function**- Spreadsheets - About.comWords or

**text**statements can be used with**Excel's**IF**function**. This tutorial includes a step by step example of how to use the IF**function**to enter**text**into a ...http://spreadsheets.about.com/od/tipsandfaqs/qt/if_enter_text.htm

**Excel**LOWER

**Function**- One of

**Excel's TEXT functions**

To convert this

**text**all to lower case (small letters) in**Excel**you can use the LOWER**function**. The syntax for the LOWER**function**is: = LOWER (**Text**).**Text**- the ...http://spreadsheets.about.com/od/excelfunctions/qt/81206_lower.htm

**EXCEL**VALUE

**Function**Tutorial - Spreadsheets - About.com

The VALUE

**function**is used to convert**text**to numbers. Doing so allows them to be used in calculations. An example of using**Excel's**VALUE**function**is included ...http://spreadsheets.about.com/od/excelfunctions/qt/81206_value.htm

**EXCEL**UPPER

**Function**Tutorial - Spreadsheets - About.com

To convert this

**text**all to upper case (capital letters) in**Excel**you can use the UPPER**function**. The syntax for the UPPER**function**is: = UPPER (**Text**).**Text**- the ...http://spreadsheets.about.com/od/excelfunctions/qt/81206_upper.htm