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
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
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920