Check the Excel Essentials Course:

Learn 3 methods to change the case of text in Excel. This way you can quickly switch text to upper case (i.e. all caps), to lower case and to proper case (first letter of every word is in capital letter and the rest are lower case letters).

Here is an overview of the three methods:
1. Excel’s Text Formulas – We use the UPPER, LOWER and PROPER functions – as well as the TRIM function to get rid of any additional spaces in between words – also space before or after words.
2. Excel Flash Fill – The advantage of flash fill is that you don’t need formulas, the disadvantage is that it’s not dynamic. If your source data change, you have to apply flash fill again.
3. Use an ALL CAPS font. There are fonts that don’t have lower case version. They are purely all caps fonts. Office has a few available by default, but you can download and install other fonts from websites like

⯆ DOWNLOAD the workbook here:

Excel Basics Playlist:

★ My Online Excel Courses ►

✉ Subscribe & get my TOP 10 Excel formulas e-book for free


Get Office 365:
Microsoft Surface:

Screen recorder:

More resources on my Amazon page:

Note: This description contains affiliate links, which means at no additional cost to you, we will receive a small commission if you make a purchase using the links. This helps support the channel and allows us to continue to make videos like this. Thank you for your support!



Xem thêm bài viết:

44 thoughts on “Change CASE of text in Excel (3 ways including NO Formulas)”

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>