To change the font style in Excel, use LOWER, UPPER or PROPER. If you don’t like using formulas, use Flash Fill to change uppercase and lowercase letters in Excel.
Join the channel Telegram of the AnonyViet 👉 Link 👈 |
How to change the font style in Excel
1. Use the LOWER function in Excel to change the text to lowercase.
2. Use the UPPER function in Excel to change the text to uppercase.
3. Use the PROPER function in Excel to change the first letter of each word to uppercase and all other letters to lowercase.
If you don’t like using formulas, you can follow these steps.
4. Enter data in cell B1.
5. On the Data tab, in the Data Tools group, click Flash Fill (or press CTRL+E).
Result:
Note: Flash Fill isn’t perfect and needs a little help sometimes.
In addition, you can also view many other excel articles here.