US Trends

how to change capital letter to small letter in excel

You can change capital letters to small letters in Excel using simple formulas or built‑in features.

Basic formula method (LOWER)

Use this when your text is in one column and you want the same text in all lowercase.

  1. Suppose your capital text is in cell A2 (e.g. "HELLO WORLD").
  2. In an empty cell (say B2), type:
    =LOWER(A2)
  1. Press Enter – the result will be hello world in B2.
  1. Drag the fill handle (small square at the bottom-right of B2) down to copy the formula for other rows.

If you want to replace the original text :

  1. Select the new lowercase results (e.g. B2:B100).
  2. Copy them (Ctrl+C).
  3. Right‑click on A2 and choose Paste Special → Values (or Home → Paste → Values).
  4. Delete the helper column B if you no longer need it.

Other useful case functions

Sometimes you don’t just want lowercase; Excel also has:

  • =UPPER(A2) – converts all letters to uppercase.
  • =PROPER(A2) – capitalizes the first letter of each word, the rest become lowercase (great for names like "JOHN SMITH" → "John Smith").

These work the same way: put the formula in another column, fill down, then paste values back if you want to overwrite the original text.

Quick one‑time fix using Flash Fill (no formulas)

For simple patterns, newer Excel versions support Flash Fill.

  1. In A2 you have HELLO WORLD.
  2. In B2, manually type hello world (the way you want it).
  3. Go to Data → Flash Fill, or press Ctrl+E.
  4. Excel will guess the pattern and fill the rest of column B accordingly.

Flash Fill is handy for one‑off cleanups, but formulas (LOWER, UPPER, PROPER) are better if your data will change in the future.

HTML snippet (table) for a quick cheat‑sheet

html

<table>
  <thead>
    <tr>
      <th>Goal</th>
      <th>Example formula</th>
      <th>Result for A2 = "HELLO WORLD"</th>
    </tr>
  </thead>
  <tbody>
    <tr>
      <td>Change capitals to lowercase</td>
      <td>=LOWER(A2)</td>
      <td>hello world</td>
    </tr>
    <tr>
      <td>Change lowercase to capitals</td>
      <td>=UPPER(A2)</td>
      <td>HELLO WORLD</td>
    </tr>
    <tr>
      <td>Capitalize first letter of each word</td>
      <td>=PROPER(A2)</td>
      <td>Hello World</td>
    </tr>
  </tbody>
</table>

Mini example story (to tie it together)

Imagine you get a client file where every customer name is in full caps: "JANE DOE", "JOHN SMITH", "ALICE LEE". You want it nicely formatted for a report. You insert a new column, use =PROPER(A2) on the first row, fill down, then paste the values back into the original name column. In under a minute, your whole list looks clean and professional instead of shouting in all caps.

Meta description (SEO):
Learn how to change capital letter to small letter in Excel using the LOWER function, Flash Fill, and more. Step‑by‑step examples and quick tips for cleaning up text case in spreadsheets.

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