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

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

**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 ... To easily convert this to proper case (which uses partial capitalization)**Excel**has the ...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**LOWER

**Function**- One of

**Excel's TEXT functions**

The LOWER

**function**is used to convert**text**to all lower case letters. ... When**text**data is imported or copied into an**Excel**spreadsheet sometimes the words ...http://spreadsheets.about.com/od/excelfunctions/qt/81206_lower.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**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**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

Truncate

**Text**Data in**Excel**with the LEFT**Function**- SpreadsheetsJan 31, 2011

**...****Excel's**LEFT**function**can be used to remove unwanted characters from imported data or truncate**text**data. This tutorial includes a step by step ...http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-left-function.htm