To capitalize text in Google Sheets, enter =PROPER(A2) in an empty cell when you want the first letter of each word capitalized, then fill the formula down. Use =UPPER(A2) for all capitals or =LOWER(A2) for all lowercase. These formulas create changed text in a separate cell, so you can check the result before replacing your original data.
“Google Excel” usually means Google Sheets, Google’s spreadsheet app. The instructions below are for Sheets in a web browser. Unlike Microsoft Excel, Google Sheets does not have a built-in Change Case command in its menus, so formulas are the most reliable way to change capitalization across a range.
What You’ll Need
- A Google account and a spreadsheet open in Google Sheets in a web browser.
- A column or range containing the text you want to change.
- An empty column for the formula results. Keeping the original text temporarily makes it easier to check for mistakes.
Step-by-Step
- Choose the capitalization style. Decide whether you need title-style capitalization, all uppercase, all lowercase, or only the first character of each cell in uppercase. For example, a list of names often suits
PROPER, while product codes may needUPPER. The formulas change the letter case, not the underlying wording or spelling. - Keep the source text in place. If your text is in column A, use a blank column such as B for the results. Add a header such as “Capitalized” in B1 if you want to label the new column. Leaving the source untouched gives you a way to compare the output and recover the original if the result is not what you intended.
- Convert each word to initial capitals. If the source text is in A2, enter this in B2 for title-style capitalization:
With the text to change in A2, enter=PROPER(A2)in B2. For example, “jordan lee” becomes “Jordan Lee.” The formula capitalizes the first letter of each word and makes the other letters lowercase. It is useful for names, labels, and headings, but it does not know which words should remain lowercase in a formal title. - Use uppercase or lowercase when that is the goal. With the source text in A2, enter
=UPPER(A2)in B2 to make every letter uppercase; “order status” becomes “ORDER STATUS.” With the source text in A2, enter=LOWER(A2)in B2 to make every letter lowercase; “ORDER STATUS” becomes “order status.” These functions leave numbers and punctuation as they are. - Capitalize only the first character in a cell, if needed. This is different from
PROPER, which capitalizes each word. With the complete text in A2, enter=IF(A2="","",UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))))in B2. For example, “hELLO THERE” becomes “Hello there.” The formula capitalizes the first character and lowercases the remainder. If a cell starts with a space, the space counts as the first character, so clean up leading spaces first if you want the first letter itself capitalized. - Check the first result. Compare the output in B2 with the original in A2. Try examples that represent the whole column: names with apostrophes, hyphenated words, abbreviations, numbers, or blank cells. The functions apply consistent case rules; they do not know that “NASA” should stay uppercase or that a particular brand spelling is intentional.
- Fill the formula down the column. Select B2, then drag the small blue square at the bottom-right corner of the selected cell down to the last row of your data. Alternatively, copy B2, select the remaining destination cells, and paste. Sheets adjusts the reference for each row, so the formula in B3 refers to A3, the formula in B4 refers to A4, and so on.
- Review the full set of results. Scan the new column for names, abbreviations, and other exceptions that need special treatment. If a result is wrong, correct the source text or edit the result after converting it to fixed values. A formula cannot infer preferred spellings, so human review matters for data that will be published or used in customer records.
- Replace the original only when you are satisfied. Copy the completed results in column B. Select the original range in column A and choose Edit > Paste special > Values only. This replaces the formulas with their displayed text, so the values no longer depend on the source cells. Check the pasted column before deleting the temporary results. You can also leave the original column intact and use the new column instead.
Common Mistakes
Expecting a menu command that is not there: Google Sheets does not include a general capitalization or Change Case button in its standard menus. Use a formula in a spare column rather than searching for an Excel-style command or typing each correction by hand.
Confusing title case with sentence case: PROPER capitalizes each word, not just the first word in a sentence. “the quick brown fox” becomes “The Quick Brown Fox,” not “The quick brown fox.” It can also change names and abbreviations in ways you may not want, so inspect important data.
Overwriting the source too soon: If you paste a formula into the same cell it refers to, you create a circular reference. Put the formula in a different column first. If you later paste results over the original, use Values only so you do not replace the source with formulas that point back to the source cells.
Filling the wrong range: A formula copied too far can create unnecessary output, while a formula not copied far enough leaves some rows unchanged. Check the last row of the source data and confirm the result column reaches that same row.
Assuming formulas preserve exact spelling: Case conversion changes capitalization consistently. It may turn a company’s chosen spelling, an acronym, or a mixed-case code into an undesired form. Keep a source copy and make exceptions manually after reviewing the results.
Tips
Use a separate results column even if you plan to replace the source. It makes the transformation reversible while you review it and lets you compare before and after values side by side. If the spreadsheet is shared, label the temporary column so collaborators understand it contains formula-generated text.
For a long list, fill down in manageable sections and inspect the output as you go. This can reveal that a column contains more than one kind of data, such as people’s names mixed with acronyms or reference codes. You may need different formulas or manual corrections for those categories.
For names that must follow a specific style, treat the formula as a first pass rather than a final authority. “PROPER” can produce a reasonable result for ordinary names, but people and organizations may use unusual capitalization. Keep an approved spelling list for recurring exceptions and correct those entries deliberately.
When you need to preserve the results as plain text, paste values only after checking the formulas. On Windows and ChromeOS, Ctrl+Shift+V pastes values only in Google Sheets. On a Mac, use Command+Shift+V. The menu route, Edit > Paste special > Values only, is a useful alternative if a shortcut behaves differently in your browser.
If your spreadsheet uses a locale with different formula separators, Sheets may expect semicolons instead of commas in formulas with multiple arguments. Follow the separator style used by other working formulas in that file. The single-argument examples =PROPER(A2), =UPPER(A2), and =LOWER(A2) do not use an argument separator.
Troubleshooting
The formula displays as text instead of a result: Check that the cell does not have a leading apostrophe before the equals sign and that the formula begins with =. If the cell is formatted as plain text, change it to automatic formatting through Format > Number > Automatic, then re-enter the formula.
You see a formula parse error: Check for missing parentheses, an incorrectly typed function name, or quotation marks that do not match. In the first-character formula, the two empty quotation marks are intentional. If your spreadsheet locale uses semicolons as separators, replace the commas between function arguments with semicolons.
The result is not the capitalization you wanted: Confirm that you selected the right function. PROPER changes every word, UPPER changes all letters to capitals, and LOWER changes all letters to lowercase. If you want only the first letter of the whole cell capitalized, use the longer formula in the steps above, not PROPER.
Some rows remain unchanged or show the wrong source: Click a result cell and inspect its formula. Confirm that it refers to the source cell on the same row and that you filled the formula through the entire data range. If rows were inserted or the source data starts on a different row, adjust the initial cell reference before filling down.
Spaces or blank cells cause surprises: The first-character formula treats a leading space as the first character. Remove unwanted leading spaces in the source before applying it, or correct those cells separately. Blank source cells should remain blank with the provided IF formula; if you used a shorter formula, an empty-looking cell may still contain a formula result.
Frequently Asked Questions
Can I capitalize text in Google Sheets without a formula?
For a range of cells, Sheets does not provide a standard Change Case menu command. You can edit cells manually, but a formula in a separate column is usually faster and easier to check.
What formula capitalizes every word?
With the text in A2, use =PROPER(A2) in another cell. It capitalizes each word and lowercases the remaining letters; check the results if the text contains acronyms or special name spellings.
How do I make an entire cell uppercase?
With the text in A2, enter =UPPER(A2) in a spare cell. Fill the formula down to apply it to more rows, then paste values only if you need fixed text.
How do I capitalize just the first letter?
Use the IF, UPPER, LEFT, MID, and LEN formula shown in the steps. It capitalizes the first character and lowercases the rest. A leading space is still a character, so remove it if the first letter should be capitalized instead.
Will the formulas change the original cells?
No. A formula placed in another cell displays a transformed result without editing the source. To replace the original text, copy the results and paste them over the source using Edit > Paste special > Values only.
Does this work in Microsoft Excel too?
Excel also has PROPER, UPPER, and LOWER functions, though the instructions and interface are for Google Sheets in a browser. Excel’s ribbon and paste-special menus differ, so use Excel’s own menu paths when working there.
Related
- How to Add in Excel Across Different Sheets
- How to Add an Image in Excel: Step-by-Step
- Add a Drop-Down in Excel and Color Its Selected Cells
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add Footnotes in Word: Desktop and WebTo add a footnote in Microsoft Word, click where its number should appear, choose References > Insert Footnote,…
- Apps Script Google Sheets Bad Request? Causes & FixesYes—“Bad Request” in a Google Sheets Apps Script usually means a request was rejected because its URL, range,…
- Clear Calendar Cache in New Outlook: Step-by-StepTo clear the calendar cache in New Outlook for Windows, open Settings > General > Privacy and data,…
- Google Sheets QUERY Formula: Syntax, Examples, and TipsIn Google Sheets, the QUERY formula filters, sorts, selects, and summarizes a table using a query written in…
- Excel Column Size: Width, Pixels, and How to Change ItIn Excel, column size is set as a width measured in character-based units, not as a fixed number…
- How to Remove a Section Break in Microsoft Word on MacTo remove a section break in Word on Mac, show formatting marks, click at the beginning of the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.