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

Clean Up Imported Data in

**Excel**with the MID FunctionNote: 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

Convert Case for

**Text**Data with the**Excel**PROPER FunctionThe PROPER function is used to convert

**text**data to proper case letters ( combination ... Spreadsheets**Excel Functions**...**Excel Functions**·**Excel Text****Functions**...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. ... When this situation occurs, certain**functions**, such as SUM or AVERAGE, ignore the ...http://spreadsheets.about.com/od/Text-Functions/ss/2011-05-26-excel-convert-text-to-numbers.htm

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

The UPPER function is used to convert

**text**to all upper case or capital letters. ... One of**Excel's TEXT functions**... Example: Using**Excel's**UPPER Function.http://spreadsheets.about.com/od/excelfunctions/qt/81206_upper.htm

Truncate

**Text**Data in**Excel**- Spreadsheets - About.comJan 31, 2011

**...****Excel**has several**functions**that can be used to truncate or remove such unwanted characters. Which function you use depends upon where ...http://spreadsheets.about.com/od/Text-Functions/ss/2011-01-31-excel-2010-truncate-text-strings-left-function.htm

**Excel**TRIM Function Alternative Formula - Spreadsheets - About.com

The TRIM function cannot always remove extra spaces from

**text**data. An alternative formula ... Tech · Spreadsheets . . .**Excel Functions**·**Excel Text****Functions**...http://spreadsheets.about.com/od/excelfunctions/qt/080404_trim.htm

Remove Extra Spaces in

**Excel**- Spreadsheets - About.com**Excel Functions**·

**Excel Text Functions**... When

**text**data is imported or copied into an

**Excel**spreadsheet extra spaces can sometimes be included along with the ...

http://spreadsheets.about.com/od/Text-Functions/ss/2011-05-28-excel-2010-trim-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