How To Change Case of Text in Microsoft Excel 2016 / 2019 Tutorial

In this comprehensive Microsoft Excel tutorial, we'll show you how to easily change the case of text, including converting text to uppercase, lowercase, and title case. We understand that many Excel users have been longing for the convenient "Change Case" command found in Microsoft Word, and in this video, we've got you covered.

Method 1: Excel Functions
We'll guide you through the first method using Excel functions. You'll learn how to apply the UPPER, LOWER, and PROPER functions to transform text in your Excel worksheets. This method provides a quick and efficient way to modify text case within Excel itself.

Method 2: Leveraging Microsoft Word
For those seeking more advanced text case options, we'll also demonstrate a second method. This involves copying the content from Excel, pasting it into Microsoft Word, changing the case using Word's versatile options, and then seamlessly pasting the modified text back into Excel. This method is perfect for users who need additional formatting choices.

Additional Resources
To make your learning experience even smoother, we've provided a sample worksheet for changing text case in Excel. You can download it in XLSX format from this link:
theteacherpoint.com/how-to-change-case-in-micro…

👧 Narrated By:
Emma (TTS)

🎺 Music Credits:
www.incompetech.com

📝 Learn More, Visit: theteacherpoint.com

✅ Recommend Playlists:

Microsoft Excel 2016 Tutorial
youtube.com/playlist?list=PLwBNdcufIBPvS995rj_6…

👌 Follow Me :
Twitter - twitter.com/TheTeacherPoint
Facebook - facebook.com/TheTeacherPoint
Instagram - instagram.com/TheTeacherPoint/
Pinterest - in.pinterest.com/TheTeacherPoint/

#exceltips #excelshortcuts #excel #excelcourse

🌻 Presented By: The Teacher