Uppercase and lowercase letters
Excel has a large number of conversion functions. This text will show the ones used to convert lowercase letters into uppercase, uppercase to lowercase, and capitalize the initial letters of each word in the given cell. We will also mention two features that are used to clean the text, either by removing excessive spaces or unprintable characters that often exist in old applications and end up in the table when retreiving data.
When converting letters we’ll use one of the three functions:
UPPER (<text>)
LOWER (<text>)
PROPER (<text>)
The UPPER function converts text to uppercase letters, LOWER into lowercase, and PROPER converts the starting letters into words in uppercase, and all the others in lowercase, like when you write someone’s name and surname.
Sometimes, text between words contains more than one space. To remove the excess spacing from the text, the function is used:
TRIM (<<text>)
Also, if you are importing text from an external source (for example, an application developed on an older platform), it happens that we import characters that can not be displayed or printed. In order to remove these characters, we use the function:
CLEAN (<text>)