schwapps.
← All guides

How to Change Case in Excel Without a Formula

Change a copied Excel column to uppercase or lowercase without formulas, with checks for names and acronyms.

Excel does not have a built-in Change Case button like Word. Its usual method is to put an UPPER, LOWER, or PROPER formula in a temporary column, then paste the values back. If you only need to clean one column and do not want formulas in the sheet, copy that column into a case-conversion tool, then paste the finished values into a new Excel column.

Change one column with copy and paste

  1. In Excel, select the text cells in one column and copy them. Keep the original column unchanged for now.
  2. Open the Schwapps case converter and paste the values into the input box.
  3. Choose lowercase, UPPERCASE, or Title Case, then run the tool. For a list, avoid Sentence case: line breaks alone do not start a new sentence in this tool.
  4. Copy the result and paste it into a blank column in Excel. Compare a few rows before replacing anything.
  5. When it looks right, use Paste Special → Values if you need to replace the original cells. Keep a copy until the workbook is checked.
Original:  aDA lovelace
Title:     Ada Lovelace
Uppercase: ADA LOVELACE
Lowercase: ada lovelace

This works best for plain, one-value-per-row text. The converter preserves line breaks. Start with contiguous, unfiltered cells without embedded tabs or line breaks, and verify the row count after pasting. Format the destination cells as Text first if Excel might reinterpret their contents. Process only the cells you intend to replace; do not paste a mixed range of names, dates, and numbers into a text-cleanup workflow.

Review names, acronyms, and brand spelling

Case conversion follows a mechanical rule. Title Case turns words into capitalized words, so it may turn iPhone into Iphone, NASA into Nasa, or O'NEILL into O'Neill. That can be a good starting point for a messy list, but it is not a reliable editor for names, initials, product names, or acronyms. Scan those rows afterward and correct exceptions manually.

Flash Fill is a different feature

Excel’s Flash Fill tries to infer a pattern after you type examples in a neighbouring column. It can sometimes reproduce capitalization, but it is prediction-based and may not be consistent across unusual names. The copy-and-paste method applies one selected case rule to every line, which makes the result easier to check. Flash Fill is useful when you want to split, combine, or rearrange text; use a case rule when the job is simply capitalization.

The Schwapps tool processes pasted text in your browser and supports up to 100,000 characters per input. For a large workbook, work in manageable sections and keep the original column until you have checked the converted values.

For the built-in alternative, see Microsoft’s Flash Fill instructions.

Open case converter ↗