PROBLEM: having to retype text when your data is in UPPERCASE, lowercase or a Mix oF bOTH.
SOLUTION: quickly change the text back to the proper case without having to retype it.
Excel – change the case of your text using CASE functions
Use the UPPER, LOWER and PROPER functions to change data to upper, lower and proper case.
The functions to use are:
=UPPER(cell reference) to change the cell contents to UPPER case.
=LOWER(cell reference) to change the cell contents to lower case.
=PROPER(cell reference) to change the cell contents to Proper case.
The examples below show how to change the data to each type of case.
The formulas displayed in column C are the formulas used to display the text in column B.
If you want to replace the formulas with the results, copy the cells containing the results and then right-click over the copied cells and select Paste Values (not the normal Paste option) to paste the data as values only.
The Case functions are included in our Excel Data Cleaning and Reporting course along with other fabulous functions like VLOOKUP and HLOOKUP.
Sharyn is an expert trainer. She became the first certified Microsoft® MOUS Authorised Instructor in New Zealand.
She is endorsed by Microsoft® as a qualified Microsoft® Office Specialist and has more than 20 years of experience in the training industry, developing and delivering technology training workshops. Her approach to taking the “techie-speak” out of technology training has placed her as a preferred supplier to many of New Zealand’s leading organisations.
If you enjoyed this you may also enjoy...
Let’s look at how to freeze a row in Excel. It can be a real pain when you don’t have freeze panes on, and when you start to scroll down the screen you lose the headings at the top of your columns.
Learn how to use Conditional Formatting to identify cells that are of interest. For example, you can apply a Conditional Format that checks to see a cell’s value is greater than $500. If it is the Conditional Format can change the Fill colour of the cell. Therefore making it really easy for you (and others using
Learn how to find, modify and break links to an Excel workbook. Linking is great, until you no longer need it. Then it can be a bit of a pain. A couple of challenges may come your way if you weren’t the creator of the workbook that contains links. One challenge is identifying where the linked data
Learn how to link Link cells in the same or different Excel worksheets. Linking saves a huge amount of time (and a huge amount of mistakes) in that it allows you to create connections from one cell to another.
Use the SUMIF function to total only the cells that match your requirement. For example, if you wanted to know the total sales made by one of your sales team members you can use the SUMIF function to only add to the total the sales made by a certain member. Gold! This function saves you a
Learn how to insert an Excel function into your workbook. Excel comes equipped with a large number of pre-defined formulas. These are known as functions. There is a great amount of functions available in Excel. Each created for a specific purpose. There are functions specific to Maths, Science, Finance, and Engineering to name a few.