Filed In:
Excel Text Functions
Excel's Text Functions help you manage the text data in your spreadsheets.
Excel 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 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 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 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 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 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 tutorial includes an example to walk you through using Excel's LEFT function.
Excel 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 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 tutorial includes an example to walk you through using Excel's MID function.
Excel 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 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.