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

**Excel Text Functions**- Spreadsheets

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

Extract a

**Substring**Using the MID**Function**in**Excel**- About.com**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.prodtx.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-mid-function.htm

Convert

**Text**to Numbers in**Excel**- 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.prodtx.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. A step by step example is included with this tutorial.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

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

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

**Excel**RIGHT

**Function**to Truncate

**Text**- Spreadsheets - About.com

Sep 22, 2007

**...**The RIGHT**function**is used to truncate**text**strings in**Excel**by removing unwanted characters from the right side of a data entry. This tutorial ...http://spreadsheets.about.com/od/excelfunctions/qt/20070922_right.htm