Look Who it Was Random video

Excel - How to Change Text To Upper or Lower Case - Episode 533

489 views · Published 4 August 2009 · 2:17 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: How to Change Text To Upper or Lower Case in Excel. 

Welcome back to the MrExcel netcast! In today's episode, we have a question from Gary in England about changing text from uppercase to lowercase and vice versa. If you have a question for the podcast, please leave a voicemail or email and we'll address it in a future episode.

There are three useful functions in Excel that can help with this task. In column A, I have data that is all uppercase. In column B, I will use the LOWER function, =LOWER(A1), to convert the text to lowercase. Simply double click the fill handle to apply the formula to all cells in the column. This is a quick and easy way to change the case of your text.

On the other hand, if you want to convert lowercase text to uppercase, you can use the UPPER function, =UPPER(B1). This will capitalize all letters in the text. Another interesting function is the PROPER function, which is great for converting names to proper case. For example, if we have "Bill Jelen" in cell D1 and use =PROPER(D1), it will capitalize the first letter of each word.

Now, you may be wondering how to change the text in column A from uppercase to lowercase without using a formula. Well, you can simply copy the formula and paste special values. To do this, select the formula, right click on the border, drag it to the new location, and select "copy here as Values Only". This will replace the original values in the column with the new values from the formula. Then, you can delete the extra formulas.

And there you have it! The UPPER, LOWER, and PROPER functions are great tools for converting the case of your text in Excel. Thanks for tuning in to this netcast from MrExcel. Don't forget to leave your questions for future episodes and we'll 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/


Gary asks about converting text from lower case to upper case an vice versa. Episode 533 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Table of Contents:
(00:00) Introduction and question from Gary
(00:20) Three functions for changing case
(00:31) Lower function for converting uppercase to lowercase
(00:47) Upper function for converting lowercase to uppercase
(01:00) Proper function for capitalizing first letter of each word
(01:22) Copying and pasting formula as values
(01:48) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Converting text from lowercase to uppercase in Excel
Converting text from uppercase to lowercase in Excel
Converting text to proper case in Excel
Copying formulas and pasting as values in Excel
Deleting extra formulas in Excel
Functions for converting text case in Excel: LOWER, UPPER, PROPER
How to use the LOWER function in Excel
How to use the PROPER function in Excel
How to use the UPPER function in Excel
MrExcel netcast on text case conversion functions
MrExcel netcast question about changing text case
YouTube video on changing text case in Excel

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

More from this channel