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 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.