To make small letters into CAPITAL letters in Excel, use the UPPER function or built-in text tools. Here’s a clear, slightly casual walkthrough you can follow.

Quick Scoop: Main Ways to Convert to CAPITALS

1. Using the UPPER formula (most common)

This is the standard way and works in all modern Excel versions.

  1. Suppose your lowercase text is in cell A2.

  2. Click an empty cell next to it, e.g., B2.

  3. Type this formula:
    =UPPER(A2)

  4. Press Enter – the text will appear in ALL CAPS.

  5. Drag the fill handle (small square at the bottom-right of B2) down to apply to the whole column.

If you want to replace the original data:

  1. Select the new capitalized cells (e.g., B2:B100).
  2. Press Ctrl + C to copy.
  3. Right‑click the original column (e.g., A) and choose Paste Special → Values.
  4. Now you can delete the helper column if you like.

This is exactly how most guides describe converting lowercase to uppercase with the UPPER function in Excel.

2. Other useful case functions

Excel has three key text-case formulas:

  • =UPPER(A1) → converts all letters to uppercase.
  • =LOWER(A1) → converts all letters to lowercase (if you ever need the reverse).
  • =PROPER(A1) → makes the first letter of each word capital, like names: "john smith" → "John Smith".

These are helpful when your data comes in messy from imports or old files and you want it to look consistent and professional.

3. Flash Fill trick (Excel 2013+)

If you don’t like formulas, Flash Fill can “learn” your pattern.

  1. Assume your text is in column A (A2:A10).
  2. In B2, manually type the capitalized version of A2 (e.g., A2 = hello, B2 = HELLO).
  1. Go to B3 and start typing the next capitalized value.
    • Excel usually shows a gray preview for the rest of the column.
  2. Press Enter to accept the suggestion.

This works best when the pattern is clear and consistent.

4. Power user: Macro to convert in-place

If you often need to convert text to uppercase in the same cells , a simple macro can do it in one go.

  1. Press Alt + F11 to open the VBA editor.

  1. Insert → Module.

  2. Paste this code:

    vba

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

  3. Close VBA.

  4. Back in Excel, select the cells you want to convert.

  5. Press Alt + F8, choose ConvertToUppercase, then click Run.

All selected cells will become ALL CAPS without needing helper columns. Just remember: this permanently changes the values, so consider keeping a backup.

5. Why this is a trending “how‑to”

Converting small letters to capital letters in Excel shows up a lot in Q&A forums, YouTube tutorials, and blog posts, because:

  • People import data from systems that send everything in lowercase.
  • Names, product codes, and titles look more professional in consistent case.
  • It’s a simple Excel skill that saves a surprising amount of time once you know it.

You’ll often see the exact phrase “how to make small letter to capital letter in excel” used as a “how do I…” question title in guides and forum threads.

Mini HTML table: Methods at a glance

html

<table>
  <tr>
    <th>Method</th>
    <th>What you type/do</th>
    <th>Good for</th>
  </tr>
  <tr>
    <td>UPPER formula</td>
    <td>=UPPER(A2)</td>
    <td>Reliable, works in all Excel versions, easy to copy down a column.[web:1][web:3][web:7]</td>
  </tr>
  <tr>
    <td>PROPER formula</td>
    <td>=PROPER(A2)</td>
    <td>Names or titles where only the first letter of each word should be capitalized.[web:7]</td>
  </tr>
  <tr>
    <td>Flash Fill</td>
    <td>Type one example in caps, then let Excel fill the pattern</td>
    <td>Quick one‑off transformations without learning formulas.[web:1]</td>
  </tr>
  <tr>
    <td>Macro (VBA)</td>
    <td>Run ConvertToUppercase on selected cells</td>
    <td>Power users who repeatedly need in‑place uppercase conversion.[web:1]</td>
  </tr>
</table>

Bottom note: Information gathered from public forums or data available on the internet and portrayed here.