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

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

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

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

**Function**- Spreadsheets - About.com

Choose

**Text**from the ribbon to open the**function**drop down list. Click on REPLACE in the list to bring up the**function's**dialog box. In the dialog box, click on the ...http://spreadsheets.about.com/od/excelfunctions/qt/080817_replace.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