This article describes the formula syntax and usage of the LEFT function in Microsoft Excel.
Description
LEFT returns the first character or characters in a text string, based on the number of characters you specify. The LEFT is also used for standardization of data.
Read more LEFT Function
This article describes the formula syntax and usage of the RIGHT function in Microsoft Excel.
Description
RIGHT returns the last character or characters in a text string, based on the number of characters you specify. The RIGHT is also used for standardization of data.
Read more RIGHT Function
The CLEAN function is used to removes all nonprintable characters from text. Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
Read more CLEAN Function
This function is used to join two or more text strings into one string.
Read more CONCATENATE Function
The EXACT function is used to Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise. EXACT is case-sensitive but ignores formatting differences. Use EXACT to test text being entered into a document.
Read more EXACT Function