Change CASE of text in Excel (3 ways including NO Formulas)

Save
2 years ago
16
Change case of text in excel change case in excel remove spaces in excel excel change case without formula change lowercase to uppercase in excel upper case without formulas proper function lower function excel uppercase to lowercase Upper function excel flash fill

April 4, 2019 Excel Introduction - Learn Excel Basics

Check the Excel Essentials Course: https://courses.xelplus.com/p/learn-excel-essentials

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 dafont.com

⯆ DOWNLOAD the workbook here: https://www.xelplus.com/excel-change-case-of-text/

Excel Basics Playlist: https://www.youtube.com/playlist?list=PLmHVyfmcRKyx1KSoobwukzf1Nf-Y97Rw0

★ My Online Excel Courses ► https://courses.xelplus.com

✉ Subscribe & get my TOP 10 Excel formulas e-book for free
https://www.xelplus.com/free-ebook/

EXCEL RESOURCES I Recommend: https://www.xelplus.com/resources/

Get Office 365: https://microsoft.msafflnk.net/15OEg
Microsoft Surface: https://microsoft.msafflnk.net/c/1327040/451518/7593

GEAR
Camera: https://amzn.to/2FLiFho
Screen recorder: http://techsmith.pxf.io/c/1252781/347799/5161
Microphone: https://amzn.to/2DVKstA
Lights: http://amzn.to/2eJKg1U

More resources on my Amazon page: https://www.amazon.com/shop/leilagharani

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!

#MsExcel

Loading comments...