MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Upper Case Excel Data in Word


October 17, 2017 - by Bill Jelen

Upper Case Excel Data in Word

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!

Download File

Download the sample file here: Podcast2050.xlsm

Title Photo: Joenomias / Pixabay


Bill Jelen is the author / co-author of
Excel Dynamic Arrays Straight to the Point

The new Dynamic Array Functions are just one side-effect of an effort to completely rewrite the Calculation Engine in Excel. Joe McDaid and the rest of the CALC team have the laid the groundwork for all future functions in Excel. Yes, the first crop of SORT, SORTBY, FILTER, UNIQUE, SEQUENCE and RANDARRAY are awesome and powerful, but they are just the first of many new functions that will come to Office 365 over the coming years.