When text is imported into EXCEL the format may need editing to match the style of the EXCEL table. The following functions can adjust text lower and upper case to unify text formatting.
The LOWER function returns all text as lower case:
= LOWER(text)
The UPPER function returns all text as upper case:
= UPPER (text)
The PROPER function returns text with the first letter of each word as upper case and the rest of the letters in each word as lower case:
= PROPER(text)
The following example shows the return result of the UPPER, LOWER and PROPER functions on a string of text with various upper and lower case letters. These functions are powerful at manipulating text to quickly and easily format inputted text that may have lower and upper case errors.
We teach most of these functions in our Basic Excel Course or our Advanced Excel Training
Download spreadsheet example here