Change CASE of text in Excel (3 ways including NO Formulas)
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
-
LIVE
Major League Fishing
7 days agoLIVE Bass Pro Tour, Heavy Hitters, Day 6
851 watching -
1:40:28
Barstool Yak
3 hours agoThe Yak with Big Cat & Co. Presented by Rhoback | The Yak 5-23-24
519 -
DVR
XrayGirl
2 hours agoGhost of Tsushima | Asian Man Simulator Part 9
1272 -
5:31
Hi-Rez
6 hours agoMeme Wars Episode 1 (Cartoon Series)
8.34K12 -
1:48:46
Russell Brand
6 hours ago‘THE TRUTH - Why the West has Lost Its Faith’ - Stay Free #372
100K137 -
LIVE
The Charlie Kirk Show
2 hours agoBiden's Amnesty Attack + Mumford and Sons Populism | Sen. Scott, Searcy, Marshall | LIVE 5.23.24
7,372 watching -
1:27:55
TheAlecLaceShow
2 hours ago$7 Billion Dollar Bribe | Unified Reich Hoax | Bronx Embraces Trump | Butker | The Alec Lace Show
11.6K4 -
1:09:24
The Dan Bongino Show
6 hours agoLive With Patrick Bet-David (Ep. 2256) - 05/23/2024
402K723 -
1:38:32
vivafrei
5 hours agoJournalist Steve Baker: Attacking James O'Keefe and Defending the FBI? Viva Frei Live
44K43 -
59:58
Dave Portnoy
4 hours agoThe Unnamed Show With Dave Portnoy, Kirk Minihane, Ryan Whitney - Ep. 15
19.3K3