how to change small letter to capital letter in excel

**Capitalize Small Letters in Excel**

By Emily Wilson
AD

In the vast realm of data management, Microsoft Excel stands as a quintessential tool, offering a plethora of features to streamline tasks and optimize workflows. One such feature is the capability to transform text from lowercase to uppercase or vice versa. Today, we delve into the world of Excel's capitalization conversion, focusing on how to change small letters to capital letters effortlessly.

Before we dive into the step-by-step procedures, let's understand the difference between uppercase and lowercase. Uppercase, often referred to as capital letters, are normally used at the beginning of a sentence or proper nouns. Lowercase letters, on the other hand, are used for the rest of the text. In Excel, the default behavior is to store data as uppercase, but it is often displayed as lowercase. Here's how you can change that.

The Thread of Text: Excel's PROPER Function

The PROPER function in Excel is like a magic wand that can transform your text into more presentable uppercase and lowercase letters. It capitalizes the first letter of each word and keeps the rest in lowercase. Let's explore its usage.

AD
the words capitalization in excel written on a gray and black background with white lettering
the words capitalization in excel written on a gray and black background with white lettering
How to Change Text to Uppercase, Lowercase, Propercase in Excel - ExcelDataPro
How to Change Text to Uppercase, Lowercase, Propercase in Excel - ExcelDataPro
how to convert small letters to capital letters in ms excel in urdu / hindi || ms excel tips in urdu
how to convert small letters to capital letters in ms excel in urdu / hindi || ms excel tips in urdu

Format: PROPER(text)

Using the PROPER Function in Excel

To use the PROPER function, follow these steps:

How to Capitalize First Letter in Excel | Proper Function in Excel |Microsoft Excel | Excel Tutorial
How to Capitalize First Letter in Excel | Proper Function in Excel |Microsoft Excel | Excel Tutorial
81K views · 952 reactions | Wondering how to change all uppercase to lowercase in Excel? This quick guide shows the easiest way to convert capital letters into lowercase using Excel formulas—no VBA needed! Ho | Excel Formula Hub
81K views · 952 reactions | Wondering how to change all uppercase to lowercase in Excel? This quick guide shows the easiest way to convert capital letters into lowercase using Excel formulas—no VBA needed! Ho | Excel Formula Hub

1. Select the cell where you want the converted text to appear. For instance, if you want to change "hello world" to "Hello World", select the cell where "Hello World" should appear.

2. In the 'Formula Bar', type the formula: =PROPER(A1), replacing "A1" with the cell that contains the text you want to convert.

AD

3. Press Enter. Excel will display the converted text in the selected cell.

Applying the PROPER Function to Multiple Cells

If you want to apply the PROPER function to multiple cells, you can use the 'Fill Handle'. After using the function in one cell, you can simply drag the fill handle to apply it to other cells.

1. After entering the formula, click and hold on the small square at the bottom-right corner of the cell (the 'fill handle').

AD

2. Drag the fill handle over the cells where you want to apply the conversion.

3. Release the fill handle. Excel will apply the PROPER function to all the selected cells.

The Power of Formatting: Changing Text Case

Another way to change the case of your text in Excel is through the use of formatting options. This method is particularly useful when you want to change the case of a selected range of cells without affecting the underlying data.

AD

Format: Right-click > Format Cells > Number > Custom > [/formula to change text case]

Changing Text Case Using Custom Format

To change the case of your text using custom format, find your text under the 'Home' tab, and do the following:

1. Select the cells containing the text you want to convert.

2. Right-click on the selection and choose 'Format Cells'.

3. In the 'Number' tab, select 'Custom' from the 'Category' list on the left side.

4. In the 'Type' field, enter the formula to change the case of your text. For instance, to convert all letters to uppercase, use @.

5. Click 'OK'. Excel will apply the formatting to your selected text.

Changing Text Case Using Text to Columns or Flash Fill

While not a direct method for changing case, Excel's Text to Columns or Flash Fill features can help you separate capital and lowercase letters, allowing you to work with them independently.

Remember, changing the case of your text might cause your data to grow or shrink, so make sure to adjust your column widths accordingly.

There you have it! Four powerful methods to change small letters to capital letters in Excel. Mastering these techniques will not only help you maintain consistency in your data but also enhance its readability. Happy formatting!

AD