Excel's Text Functions help you manage the text data in your spreadsheets.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
