Home » Our Blog » Excel – change text to uppercase, lowercase or first capital

Excel – change text to uppercase, lowercase or first capital

close up photography of brown jukebox letter keys

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.

Excel change the case of text

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...

How to freeze a row in Excel

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. 

​Read More

Use Conditional Formatting to identify cells that are of interest

  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

​Read More

Find, modify and break links to an Excel workbook

  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

​Read More

Insert an Excel function into your workbook

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. 

​Read More