How to Change Small Letters to Capital Letters in Excel

How to Change Small Letters to Capital Letters in Excel

by

If you work with text data in Microsoft Excel, you may often need to convert small letters (lowercase) into capital letters (uppercase). The easiest and most popular way to convert lowercase text to uppercase is by using the UPPER function.

The good news is Excel provides simple built-in formulas to do this instantly.

In this complete step-by-step guide, you’ll learn different methods to convert small letters to capital letters in Excel easily.

Why Convert Small Letters to Capital Letters in Excel?

Introduction to Computer: Basics, Parts, Functions, and Uses Explained

Before learning the steps, here are some common reasons people change lowercase text to uppercase:

  • Standardize names and headings
  • Improve readability of data
  • Maintain consistent formatting
  • Prepare data for reports or databases
  • Clean imported or copied data

Method 1: Convert Small Letters to Capital Using the UPPER Function (Best Method)

The UPPER function is the easiest and most commonly used way to convert lowercase text into uppercase.

What is the UPPER Function?

It converts all letters in a text string to capital letters.

Formula Syntax

=UPPER(text)

Step-by-Step Example

Let’s say you have lowercase names in Column A:

A (Names)
rajesh
amit
sunita

You want to convert them into capital letters.

Step 1: Select an empty cell

Click on cell B1 (or any empty cell next to your data).

Step 2: Enter the formula

Type the formula:

=UPPER(A1)

Step 3: Press Enter

The result will appear in capital letters:

RAJESH

Step 4: Apply to all cells

Drag the fill handle (small square at bottom right of the cell) downward to apply the formula to other rows.

Now all names will be in uppercase.

Method 2: Convert Capital Text Permanently (Remove Formula)

When you use formulas, the original data remains unchanged. If you want to replace the original text permanently, follow these steps:

Step-by-Step

  1. Convert text using the UPPER formula.
  2. Select the converted results.
  3. Press Ctrl + C to copy.
  4. Right-click on original cells.
  5. Click Paste Special → Values.

Now the uppercase text replaces the original data permanently.

Method 3: Convert Text Case Using Flash Fill (Excel 2013 and Later)

100 Important Computer GK Questions and Answers in English

Flash Fill automatically detects patterns and fills data for you.

Steps

  1. In the next column, manually type the uppercase version of the first word.
    Example:
    If A1 = rajesh → type RAJESH in B1.
  2. Press Enter.
  3. Press Ctrl + E (Flash Fill shortcut).

Excel will automatically convert all remaining entries into capital letters.

Method 4: Convert Selected Text Using Power Query (Advanced Users)

If you’re working with large datasets, Power Query is helpful.

Basic Steps

  1. Select your data.
  2. Go to Data → From Table/Range.
  3. In Power Query Editor, select the column.
  4. Click Transform → Format → UPPERCASE.
  5. Click Close & Load.

Your data will be converted into capital letters.

Method 5: Convert Text Using VBA (Automation Method)

If you frequently need to change text case, VBA automation can help.

VBA Code Example

Sub ConvertToUppercase()
    For Each cell In Selection
        cell.Value = UCase(cell.Value)
    Next cell
End Sub

How SEO-Friendly Steps to Use It

  1. Press Alt + F11 to open VBA Editor.
  2. Insert a new module.
  3. Paste the code.
  4. Select cells and run the macro.

All selected text will convert to uppercase instantly.

Bonus Tip: Convert to Proper Case or Lowercase

Excel also provides other useful functions:

FunctionUse
=LOWER(A1)Converts text to small letters
=PROPER(A1)Capitalizes first letter of each word

Example:
rajesh kumar → Rajesh Kumar

Common Problems and Solutions

Problem: Formula not working

  • Check correct cell reference
  • Ensure no extra spaces
  • Confirm formula starts with =

Problem: Text includes numbers or symbols

UPPER function only changes letters — numbers and symbols remain unchanged.

Example:

abc123 → ABC123

Best Method Recommendation

For most users, the UPPER function is the fastest and easiest method.

  • Simple formula
  • Works in all Excel versions
  • No advanced skills required

Frequently Asked Questions (FAQs)

How do I convert all text to uppercase at once?

Use UPPER formula, then drag down or use Flash Fill.

Can I convert text without using formulas?

Yes, use Flash Fill or VBA macro.

Will original text change automatically?

No – formulas create a new result column unless you paste values.

Final Words

Changing small letters to capital letters in Excel is very easy once you know the right method. Whether you use the UPPER formula, Flash Fill, or VBA automation, Excel gives multiple ways to format text quickly.

If you’re a beginner, start with the UPPER function it’s simple, fast, and works perfectly for everyday tasks.

Leave a Comment