Excel Guides

Character Replacement in Simple Formulas in Excel

When you enter a formula in Excel, the characters that you type are automatically converted to uppercase. This is called formula auto-correction. You can change the way that formulas are auto-corrected by changing the settings in the AutoCorrect dialog box.

To change the way that formulas are auto-corrected

  1. Click the File tab.
  2. Click Options.
  3. Click Proofing.
  4. Under AutoCorrect options, click AutoCorrect Options.
  5. In the AutoCorrect dialog box, make the changes that you want, and then click OK.

The following table lists the default settings for formula auto-correction, and explains what each setting does.

SettingWhat it does
Replace text as you typeReplaces common misspellings with correct spellings as you type them in a cell. For example, if you type teh, Excel changes it to the.
Correct TWo INitial CApitalsChanges words that have two initial capital letters to all capital letters. For example, if you type Unclear, Excel changes it to UNCLEAR.
Capitalize first letter of sentencesAdds a capital letter at the beginning of every sentence that you type in a cell. For example, if you type hello world., Excel changes it to Hello world.
Capitalize first letter of table cellsAdds a capital letter at the beginning of every word that you type in a cell. For example, if you type hello world., Excel changes it to Hello World.
Capitalize names of daysChanges all instances of days of the week to initial capitals. For example, if you type monday, Excel changes it to Monday.

Move beyond 

Excel

Get started with Causal today.
Build models effortlessly, connect them directly to your data, and share them with interactive dashboards and beautiful visuals.