Excel Text Functions

Excel CONCATENATE Function
The CONCATENATE function can be used to combine two or more words or other data together into a single cell.

Excel LEFT Function
The LEFT function can be used to remove unwanted characters from the right side of data imported into an Excel worksheet keeping the good data on the left side.

Excel RIGHT Function
Similar to the LEFT function above, except the RIGHT function removes unwanted characters from the left side of a data entry.

Excel MID Function
The MID function is related to the LEFT and RIGHT functions but it allows you to extract the good data out of the middle of an imported text entry.

Excel PROPER Function
The PROPER functionis used to convert text data to proper case letters (combination upper and lower case).

Excel 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 TRIM Function
The TRIM function can be used to remove extra spaces from between words, at the beginning or end of sentences, or between strings of characters. It is commonly used to clean up text data imported or copied into Excel.

When the TRIM Function Doesn't Work
In certain circumstances the TRIM function remove extra spaces from a text entry. This tutorial covers an alternative for removing extra spaces between data in Excel.

Excel LOWER Function
Similar to the UPPER function, the LOWER function is used to convert text to all lower case letters.

Excel REPLACE Function
The REPLACE function can be used to remove unwanted characters from a data entry or replace it with good data.

Excel VALUE Function
The VALUE function, one of Excel's text functions, is used to convert text to numbers. Doing so allows them to be used in calculations. This article includes an example to walk you through using Excel's VALUE function.

Excel SUBSTITUTE Function
The SUBSTITUTE function can be used to replace all or some of the text data that appears in one cell with new data in a second cell.

Excel CHAR Function
The CHAR function can be used to enter special characters and symbols into Excel formulas and worksheets.

Excel CODE Function
The CODE function can be used to find the ANSI code value for non-standard characters and symbols used in Excel.