How To Change Case of Text in Excel Tutorial

Aug 14, 2023

How To Change Case of Text in Excel Tutorial

In this Microsoft Excel Tutorial you will learn how to Change Case of Text like Upper to Lower, Lower To Upper, Lower to Sentence Case. Sentence to Upper Case or vice-versa.

Most of us are very fond of the Change Case command available in Microsoft Word as it sometimes really saves a lot of our time by replacing the text case in seconds. But unfortunately, everyone is missing that Change Case option in Microsoft Excel. In this tutorial, we will explain two different methods of changing the case of the text.

The first method is using the Upper(), Lower(), and Proper() Excel Functions, and the second is copying/pasting the desired column in Word, change the case using the Change Case command, and then copy/paste back to Excel.

📋 Learn More and Download the Sample Worksheet For Change Case in Excel (XLSX Format):
https://www.theteacherpoint.com/how-t…

👧 Narrated By:
Emma (TTS)

🎺 Music Credits:
www.incompetech.com

🔔 Subscribe for more tutorials: https://www.youtube.com/TheTeacher?su…

📝 Learn More, Visit: https://www.theteacherpoint.com

✅ Recommend Playlists:

Microsoft Excel 2016 Tutorial
http://bit.ly/Excel-2016-Playlist

👌 Follow Me :
Twitter - https://www.twitter.com/TheTeacherPoint
Facebook - https://www.facebook.com/TheTeacherPoint
Instagram - https://www.instagram.com/TheTeacherP…
Pinterest - https://in.pinterest.com/TheTeacherPo…

Information also applies to the following versions:
Excel 2007 / 2010 / 2013 / 2016 / 2019 / Excel 365

#ChaseCase
#ExcelTutorial
#TheTeacher

🌻 Presented By: The Teacher

Content

9.139 -> If you are familiar using Microsoft Word and Excel, then you may have always wanted the

14.049 -> 'Change Case' command in Microsoft Excel too.

18.65 -> In Microsoft Word, you can easily change the text to Upper, Lower, Title, Sentence and

24.55 -> Toggle Cases.

29.169 -> But unfortunately, this button is not available in Microsoft Excel.

33.94 -> But still you can easily accomplish this in Microsoft Excel as well.

39.17 -> To do this, you can follow two ways.

41.76 -> The first one is, using Excel Functions.

44.66 -> For instance, here I have a list of few peoples with their names and addresses.

50.98 -> I want to change the case of Name field to all upper case.

55.109 -> To do this, I will use Upper function of Microsoft Excel.

59.09 -> First, I will insert a blank column between the both Name and Address field.

64.86 -> Then, I will use the upper function.

68.64 -> Equals, Upper, parenthesis begin, then the cell reference of the corresponding cell.

75.61 -> In my case, it is B2, and then parenthesis close, and hit the enter key.

82.02 -> Now, I will copy the formula to the remaining cells.

88.17 -> As now I have 2 columns with the same values, I will hide the original one.

94.2 -> Remember that, I cannot delete the values from B column, because column C results, depends

100.17 -> on Column B. So, what I will do is to hide the actual column.

108.25 -> To do this, right-click on Column Heading B, and then click Hide.

113.96 -> Anytime, if you require the original column back, use the Unhide command.

123.46 -> Use the Lower function to convert all to lower case.

133.98 -> Use the Proper function to convert all to Title Case.

144.36 -> Excel supports only these three types of cases.

148.09 -> Garage The second method is a bit off the track.

152.7 -> To use all the sentence case types available in Microsoft Word, what you need to do is

158.15 -> to, copy the contents from Microsoft Excel, and then paste them into Microsoft Word.

168.37 -> Use the desire Change Case style.

175.17 -> Then copy the contents from Microsoft Word, and then replace them into Excel, using the