1. Home
  2. Computing & Technology
  3. Spreadsheets

Excel Text Functions

Excel's Text Functions help you manage the text data in your spreadsheets.

Excel 2007 CONCATENATE Function

The CONCATENATE function, one of Excel's text functions, is used to join two or more words or text strings together. This article includes an example to walk you through using Excel's CONCATENATE function.

Excel 2007 PROPER Function

The PROPER function, one of Excel's text functions, is used to convert text data to proper case letters (combination upper and lower case). This article includes an example to walk you through using Excel's PROPER function.

Excel 2007 UPPER Function

The UPPER function, one of Excel's text functions, is used to convert text to all upper case or capital letters. This article includes an example to walk you through using Excel's UPPER function.

Excel 2007 LOWER Function

The LOWER function, one of Excel's text functions, is used to convert text to all lower case letters. This article includes an example to walk you through using Excel's LOWER function.

Excel 2007 REPLACE Function

The REPLACE function, one of Excel's text functions, is used to replace unwanted characters from a data entry. This article includes an example to walk you through using Excel's REPLACE function.

Excel 2007 LEFT Function

The LEFT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's LEFT function.

Excel 2007 RIGHT Function

The RIGHT function, one of Excel's text functions, is used to remove unwanted characters from the right side of a data entry. This article includes an example to walk you through using Excel's RIGHT function.

Excel 2007 MID Function

The MID function, one of Excel's text functions, is used to remove unwanted characters from both the left and right sides of a data entry. This article includes an example to walk you through using Excel's MID function.

Excel 2007 TRIM Function

The TRIM function, one of Excel's text functions, is used to remove extra spaces from a text entry. This article includes an example to walk you through using Excel's TRIM function.

Excel 2007 VALUE Function

The VALUE function, one of Excel's text functions, is used to convert text to values. Doing so allows them to be used in calculations. This article includes an example to walk you through using Excel's VALUE function.
Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Excel Functions
  5. Text Functions

©2009 About.com, a part of The New York Times Company.

All rights reserved.