Excel - Upper Case Excel Data in Word - Episode 2050

1,205 views · Published 17 October 2016 · 1:35 · Indexed 8 November 2026

Channel: MrExcel.com · 2016 · Education

Watch on YouTube

Microsoft Excel Tutorial: Changing Case of Excel Data is Easier If You Copy to Word.

Welcome to another episode of the MrExcel podcast, where we bring you the best tips and tricks for mastering Excel. In today's episode, we have a special guest from the Word team, Katie Sullivan, who will be showing us how to easily change case in Microsoft Word.

We all know that Excel is a powerful tool for data analysis, but there are certain tasks that can be done more efficiently in Word. One of those tasks is changing case. Instead of going through multiple steps in Excel, we can simply copy and paste our data into Word and use the handy options on the Home tab to change the case to UPPERCASE, Capitalize Each Word, Sentence case, or lowercase.

To demonstrate this, let's say we have a list of names in Excel that we want to convert to UPPERCASE. We could add a helper column and use the =UPPER function, but that involves multiple steps. Instead, we can just copy the data, switch over to Word, and use the UPPERCASE option to quickly change the case. Then, we can copy and paste the data back into Excel, and voila, all the names are now in UPPERCASE.

If you're enjoying these tips and want to learn more, be sure to check out my book which contains all the tips from the last 70+ podcasts. Just click the "i" on the top-right hand corner to purchase the book. And a big thank you to Katie for sharing this cool Word trick with us. Stay tuned for more netcasts from MrExcel, where we continue to bring you the best Excel tips and tricks. Don't forget to like, comment, and subscribe for more helpful content. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

#excel
#microsoft
#microsoftexcel
#exceltutorial
#evergreen
#excelformatting
#betterinword

This video answers these common search terms:
can i change lower case to upper case on excel
excel how to change to uppercase
how change convert uppercase lowercase excel
how do i change uppercase to lowercase in excel
how do you change text in excel from upper case to lower case
how to change font to uppercase in excel
how to change from upper case to lower case in excel
how to convert lower case to upper in excel
how to make a column uppercase in excel
how to change lowercase to uppercase in excel
how to change uppercase to lower case on excel

Table of Contents:
(00:00) Microsoft Word's advantage in changing case
(00:24) Using helper columns in Excel
(00:34) A simpler method using Microsoft Word
(01:02) Different case options in Word
(01:19) Clicking Like really helps the algorithm

Today's trick is from Katie Sullivan on the Word team
There are a few cases where Microsoft Word can do things better than Excel
One of those is changing case.
If you needed to convert all of this text to Upper case, you could
add a helper column and use UPPER, plus then Copy & Paste Values.
The video shows how to right-drag a selection and choose Copy Here as Values Only
But, you can also round-trip the data to Word
In Word, there is a choice to convert text to UPPER, lower, Sentence, tOGGLE cASE, or Proper Case

Join the MrExcel Message Board discussion about this video at  https://www.mrexcel.com/board/threads/1153877/

More from this channel