Learn 3 super easy ways to change the case of text in Excel.UPPERCASE to lowercase, lowercase to uppercase and sentence case in Excel. Covers changing the case with and without formulas. Super quick steps, including an easy ‘hack’ using Microsoft Word.

Timestamps:
00:00 Excel Change Case of Text
01:54 #1 Excel change case without formula using Flash Fill
03:52 #2 Change case of text without formula (Excel 2010)
05:14 #3 Excel change to lowercase using the LOWER function
05:35 Change to uppercase in Excel using the UPPER function
05:45 Excel capitalize first letter using the PROPER function

Topic #90 in the ‘Steps to becoming Proficient in Excel’ workbook.

Read the full Blog post here: https://excelatwork.co.nz/2021/04/27/excel-change-case-with-or-without-a-formula/

Become an Excel at Work Insider (100% free) and grab your copy of the ‘Steps to becoming Proficient in Excel’ workbook today: https://excelatwork.co.nz/subscribe/

VERSION FRIENDLY
Try this with Excel 2010, Excel 2013, Excel 2016, Excel 2019 and Excel for Microsoft 365 (a.k.a Office 365). Sharyn’s using the desktop version of Excel for Microsoft 365 as part of the Microsoft 365 Business Standard subscription.

#ExcelTutorial #ExcelTips #ExcelBeginner #ExcelIntermediate #ExcelatWork

Please take the opportunity to connect and share this video with your friends and family if you find it useful.