• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

Change case in Excel

April 6, 2021 by Andrew Childress
Change case of multiple words Excel

When you need to change the case of text in your spreadsheets. But don't want to retype anything. Here's how to change case in Excel.

Sometimes, you need to change the case of text in your spreadsheets. But don’t worry – you won’t have to retype anything. Let’s learn how to change case in Microsoft Excel.

How to Change Case in Excel

Excel offers multiple font case options: uppercase, lowercase, and proper. Let’s learn to use all three.

First, imagine you have a word written in lowercase: forecast. But instead, you want it to read FORECAST. There’s no reason to retype the word. Instead, simply click into an empty cell and type an = sign to begin a formula. Type UPPER(, then click into the cell containing the word forecast. Type ), and your formula will read:

=UPPER(B1)

Change case in Excel

Press Enter. The word FORECAST appears in the second cell. From here, you can cut and paste into the original cell to replace the lowercase version.

Change font case in Excel

Changing uppercase to lowercase works similarly. In that instance, your formula is:

=LOWER(B2)

Change case of Excel font

The last option is PROPER, which essentially adds capitalization. For instance, FORECAST or forecast would change to Forecast. This formula is:

=PROPER(B3)

Change case of text Excel

How to Change Case of Multiple Words in Excel

Now, imagine that you have several cells that you want to change the case of. There’s no need to retype your formulas again, provided you want to make the same change for every cell in the column.

Consider a list of words like this. In cell D1, go ahead and input a formula. For practice, let’s use =UPPER(C1).

Hit Enter, and you’ll see the uppercase word appear in cell D1. Now, with cell D1 selected, hover over its lower right corner until you see a black + sign appear. Click and drag downward into the cells adjacent to the other words, and Excel will automatically correct them.

Change case of multiple words Excel

As you can see, it’s very easy to change the case of text in Microsoft Excel. Even better: you don’t have to retype a single word.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post: « Greater than or equal to Excel Greater Than or Equal To in Excel
Next Post: Multiply in Excel Multiply Excel »

Sidebar

Recent Posts

  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel
  • EXACT in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

  • Facebook
  • Twitter
  • Instagram
  • LinkedIn
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2022 · Excelypedia · All Rights Reserved

Back to top