How to Convert Capital Letters to Lowercase in Excel . The LOWER function does exactly what you’d expect—it converts all letters to lowercase.

Step 4: Select “Sentence case” In the list of options, select “Sentence case.” Excel will automatically convert all text in the selected range to sentence case. If you want to make sure that your data ...

Excel has over 475 formulas in its Functions Library, from simple mathematics to very complex statistical, logical, and engineering tasks such as IF statements (one of our perennial favorite ...