How to Convert All Caps to Proper Case in Excel: A Step-by-Step Guide

How to Convert All Caps to Proper Case in Excel

Turning your ALL CAPS INTO Proper Case in Excel is a breeze. Simply use the Excel functions to change the text from uppercase to proper case. Here’s how to do it step-by-step: you’ll use the "PROPER" function to convert text in cells from all caps to proper case, making your data more readable and professional.

Step by Step Tutorial on How to Convert All Caps to Proper Case in Excel

This tutorial will guide you through the process of converting all uppercase text in Excel into proper case, where the first letter of each word is capitalized and the rest are in lowercase.

Step 1: Open your Excel file

Ensure the Excel file with the text you want to convert is open.

Open your workbook and navigate to the sheet where your all-caps text is located. This step is essential, as you’ll need to have the file ready for editing.

Step 2: Select an empty cell

Pick an empty cell where you want the converted text to appear.

You’ll need a space to enter the formula and display the converted text. Make sure it’s near the original data for easy reference.

Step 3: Enter the PROPER function

Type =PROPER(A1) in the empty cell (replace A1 with the actual cell reference).

This formula uses the "PROPER" function to convert the text in cell A1 to proper case. Adjust the cell reference according to your data location.

Step 4: Copy the formula down

Drag the fill handle down to apply the formula to other cells.

After entering the formula, you’ll need to apply it to the entire range of your data. Click and drag the small square at the bottom-right corner of the cell where you entered the formula.

Step 5: Copy and paste the results as values

Copy the cells with the formulas and paste them as values to replace the original text.

Highlight the cells with the converted text, right-click, select "Copy," then right-click again and choose "Paste Special" > "Values." This step replaces the formulas with the actual text.

After completing these steps, your text will be converted from all caps to proper case. This makes your spreadsheet look cleaner and more professional.

Tips on How to Convert All Caps to Proper Case in Excel

  • Always keep a backup of your original data before making changes.
  • Use the "Find and Replace" feature to quickly spot and fix any remaining issues.
  • If dealing with a large dataset, consider using a macro to automate the process.
  • Familiarize yourself with other text functions like "UPPER" and "LOWER" for more text manipulation options.
  • Practice using these functions on a small dataset to get comfortable before applying them to critical data.

Frequently Asked Questions

How do I convert text to proper case without using a formula?

You can use Microsoft Word’s "Change Case" feature, then copy and paste the text back into Excel.

Can I use this method on multiple columns at once?

Yes, apply the formula to each column separately or use a macro to automate the process across multiple columns.

What if my text includes acronyms or abbreviations?

The "PROPER" function will capitalize the first letter of each word, so you’ll need to manually adjust acronyms or abbreviations.

Is there a way to undo the changes if I make a mistake?

Yes, use the "Undo" feature or revert to your backup copy of the original data.

Can I use this method in Google Sheets?

Yes, Google Sheets also supports the "PROPER" function, and the steps are similar.


  1. Open your Excel file.
  2. Select an empty cell.
  3. Enter the PROPER function.
  4. Copy the formula down.
  5. Copy and paste the results as values.


Mastering the ability to convert all caps to proper case in Excel is a handy skill that can significantly enhance the readability and professionalism of your spreadsheets. By following the simple steps outlined in this guide, you can quickly and efficiently transform your text. Remember, practice makes perfect, so don’t hesitate to experiment with the "PROPER" function and other text functions on smaller datasets before tackling larger projects.

If you’re hungry for more Excel tips and tricks, consider exploring additional resources or tutorials. Excel is a powerful tool, and the more you learn about its capabilities, the more effective you’ll become in managing and presenting your data. So go ahead, give it a try, and elevate the quality of your spreadsheets today!

Get Our Free Newsletter

How-to guides and tech deals

You may opt out at any time.
Read our Privacy Policy