Enter =PROPER(A2) in B2 to capitalize each word from A2, then fill down. To remove extra normal spaces too, use =PROPER(TRIM(A2)). Check the results before copying and pasting them as values.
On this page8
Keep the source text in column A and leave B available as a helper column.
Enter =PROPER(A2) in B2, or =PROPER(TRIM(A2)) if extra normal spaces need removing.
Fill the formula down. Check acronyms and names individually: PROPER applies a character rule, not a dictionary of names.
If you want to replace A, copy the checked B results and use Paste Special > Values over A. Confirm the pasted values before deleting B.
Try PROPER and check the exceptions
Paste these inputs into A1 of a spare sheet. Enter =PROPER(A2) in B2 and fill to B5. Compare with the expected results before replacing any original text.
37 characters
A1Capitalize each word
=PROPER(A2)Also remove extra normal spaces
=PROPER(TRIM(A2))| A: Original | B: =PROPER(A2) |
|---|---|
| ANNA MEYER | Anna Meyer |
| nASA research | Nasa Research |
| don't PANIC | Don'T Panic |
| anna meyer | Anna Meyer |
If columns are cut off, scroll the table sideways.
- The live tool starts in Proper mode. It converts your text, while the formula uses the A2 cell reference.
- NASA becomes Nasa and don’t becomes Don’T; edit exceptions deliberately. PROPER is not sentence case.
- The fourth input retains spaces with PROPER alone. Use TRIM only when those spaces are unwanted.
- Keep the original column until the pasted values have been checked.
Documentation reviewed .
What PROPER changes
PROPER uppercases a letter after a non-letter and lowercases the other letters. ANNA MEYER becomes Anna Meyer. NASA becomes Nasa, and an apostrophe starts another segment, so don’t becomes Don’T. It does not remove spaces. UPPER makes all letters uppercase; LOWER makes them lowercase. These are separate transformations, so choose the one your source data needs.
A helper column you can check
Paste the example inputs below into A1, including its header. Put =PROPER(A2) in B2 and fill down to B5. The expected results show why initials and apostrophes need review. For the padded name, =PROPER(TRIM(A5)) returns Anna Meyer. Copy only the results you have checked, then use Paste Special > Values if you need a replacement rather than formulas.
In Google Sheets
Google Sheets also provides PROPER and TRIM. The same English formulas can be used in a helper column. Function names and argument separators can depend on spreadsheet settings. Neither app’s PROPER function knows whether a brand acronym or a particular person’s name should keep its original capitalization.
If the formula appears as text
Check whether the helper cell is formatted as Text or starts with an apostrophe. Change the helper cell to General, remove a leading apostrophe if present, then re-enter the formula. If the whole sheet shows formulas instead of results, check Show Formulas. A #NAME? error can mean the function name is misspelled or needs its localized name. Check that A2 points to the intended source text before filling down.
Keep an acronym deliberately
For a column where the exact value NASA must remain uppercase, one explicit exception is =IF(A2="NASA",A2,PROPER(A2)). This checks the whole cell; it does not preserve NASA inside a longer phrase. For mixed names, brands and initials, keep a separate exception list or review the helper results. A general capitalization rule cannot infer the spelling preferred by a person or organization.
Common mistakes
- Changing acronyms such as NASA to Nasa without checking the result.
- Assuming PROPER removes spaces or preserves apostrophes in natural-language casing.
- Deleting the helper column before pasting its formulas as values.
- Using a whole-column replacement without keeping a copy of the original text.
Frequently asked questions
Can I capitalize each word without changing the source column?
Yes. Use =PROPER(A2) in B2 and fill down. Column A remains unchanged until you deliberately paste results over it.
How do I capitalize words and remove extra spaces?
Use =PROPER(TRIM(A2)). TRIM removes leading, trailing and repeated normal spaces; non-breaking spaces need separate handling.
Why does PROPER change NASA or apostrophes?
It lowercases all letters except those following non-letters. It does not apply name, acronym or sentence-case rules.