Upper Case Excel Data in Word
October 17, 2017 - by Bill Jelen
How to change case of Excel data. Whether you have to convert to upper case, lower case, sentence case or proper case, this article will show you how to convert the case.
Note
Katie Sullivan is a Project Manager on the Microsoft Word team. For today's tip, a benefit of Word.
While Excel fans sometimes tease that Word and PowerPoint are freeware apps that come on the Excel DVD, there are times when Microsoft Word offers a feature that Excel does not. In those cases, it makes sense to copy your data from Excel, paste to Word, do the command, then copy back to Excel. Here are some examples of techniques that are better handled in Word than in Excel.
Technique 1
Convert to Upper, Lower, Proper
If you have to convert from uppercase to lowercase or proper case, Word has a keystroke shortcut. Copy the data to Word and toggle the case using Shift + F3.
Watch Video
- 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
Video Transcript
Learn Excel from MrExcel podcast, episode 2050 - Change Excel Data to Upper Case in Word!
Hey, I am podcasting all my tips from this book, click that “i” on the top-right hand corner to see the playlist!
Alright, today's trick from Katie Sullivan on the Word team. There's a few cases where Microsoft Word can do things easier, faster, better than Excel, and one of those is changing case. If you needed to convert all this text to UPPERCASE, you could come over here and add a little helper column with =UPPER, =LOWER, =PROPER. Double-click to copy that down, and then right-click, drag right, and say Copy Here as Values Only, but that's a lot of steps, so let's undo.
Instead, let's take the data, Ctrl+C, and then, we'll switch over to Microsoft Word and paste. Select all that text and right here, this beautiful setting on the Home tab will go to UPPERCASE like that. We also have options for Capitalize Each Word, or Sentence case, or lowercase, ah, but our goal today is UPPERCASE, will choose that, Ctrl+C to copy, go back to Excel, paste in place, BAM, everything is in uppercase. Alright, all of the tips from the last 70+ podcasts are in this book, click that “i” in the top-right hand corner to buy the book. Thanks to Katie for this cool Word trick.
We’ll see you next time for another netcast from MrExcel!
Title Photo: Joenomias / Pixabay
