### 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/

Clean Up Imported Data in

**Excel**with the MID**Function**Note: Even though the MID

**function**is one of**Excel's Text functions**, the**function**can also be used to extract a subset of numeric data from a longer number using ...http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm

**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

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

**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

**Excel**LOWER

**Function**- One of

**Excel's TEXT functions**

The LOWER

**function**is used to convert**text**to all lower case letters. A step by step example is included with this tutorial.http://spreadsheets.about.com/od/excelfunctions/qt/81206_lower.htm

**EXCEL**UPPER

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

The UPPER

**function**is used to convert**text**to all upper case or capital letters. An example of using this**function**is included in the tutorial.http://spreadsheets.about.com/od/excelfunctions/qt/81206_upper.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**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**REPLACE

**Function**- Spreadsheets - About.com

**Excel's**REPLACE

**function**can be used to replace these unwanted characters with good data ... Choose

**Text**from the ribbon to open the

**function**drop down list .

http://spreadsheets.about.com/od/excelfunctions/qt/080817_replace.htm