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
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
Transcript of the video:
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!
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!
