For a cell in A2, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))) to capitalize the first character and make the rest lowercase. This handles one sentence—or the whole cell as one unit—but it does not capitalize the start of every sentence; a Microsoft 365 formula for that is included below.
The basic Excel sentence case formula
Suppose A2 contains tHE QUICK BROWN FOX. The formula returns The quick brown fox. It changes the result in a separate cell and leaves the original text untouched, so you can compare the two before deciding whether to replace the source.
With the original text in A2, enter this formula in B2:
=UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2)))
Here, LEFT takes the first character, UPPER capitalizes it, and MID returns the text beginning with the second character. LEN supplies the number of characters to return. LOWER makes all those remaining characters lowercase. The ampersand joins the two pieces into one text value.
The result is a common interpretation of sentence case: the first character is uppercase and the rest are lowercase. It works well for a single sentence or a heading where you want only the first letter capitalized. However, Excel does not have a built-in worksheet function named SENTENCECASE, and this short formula does not understand where separate sentences begin.
What sentence case means in a spreadsheet
Sentence case usually means capitalizing the first word of a sentence while leaving other words lowercase, except for proper nouns, acronyms, and other words that have their own capitalization. Excel cannot reliably determine which words are names or acronyms. A formula that changes NASA REPORT FOR JANE to sentence case may produce Nasa report for jane, even though the intended result might be NASA report for Jane.
That is why formula-based capitalization is a mechanical text conversion, not a proofreading tool. It can change letter case consistently, but it cannot know whether a word is a person’s name, a brand, a place, or an abbreviation. Plan to review names and specialized terms after conversion.
Also distinguish sentence case from title case. Title case capitalizes many or most words in a heading; sentence case generally capitalizes only the first word and words that should retain special capitalization. Excel’s PROPER function is often used for title-style capitalization, but it is not a substitute for sentence case.
How the basic formula works
With the input in A2 and the formula in B2, the pieces can be read separately:
LEFT(A2,1)returns the first character from A2.UPPER(...)converts that character to uppercase.MID(A2,2,LEN(A2))returns the text starting at character 2.LOWER(...)converts that remaining text to lowercase.- The ampersand combines the uppercase first character and lowercase remainder.
For example, with mY fAVORITE color IS BLUE in A2, the result is My favorite color is blue. The formula does not add a period, remove extra spaces, or otherwise edit the text. If A2 is blank, the result is blank. If the first character is a space, that space remains the first character, so the first visible letter may stay lowercase. Clean leading spaces if that matters.
Capitalize the start of each sentence
If A2 contains several sentences, the basic formula only capitalizes the very first character. For example, it turns tHE QUICK BROWN FOX. it JUMPS! into The quick brown fox. it jumps!. In Microsoft 365 for Windows, you can use MAP and LAMBDA to capitalize the first character and the first non-space character following a period, exclamation mark, or question mark.
With the complete text in A2, enter this formula in B2:
=LET(t,LOWER(A2),n,LEN(t),i,SEQUENCE(n),TEXTJOIN("",TRUE,MAP(i,LAMBDA(k,LET(ch,MID(t,k,1),prev,IFERROR(LOOKUP(2,1/(MID(t,SEQUENCE(k-1),1)<>" "),SEQUENCE(k-1)),0),IF(OR(k=1,AND(ch<>" ",prev>0,OR(MID(t,prev,1)=".",MID(t,prev,1)="!",MID(t,prev,1)="?"))),UPPER(ch),ch))))))
With tHE QUICK BROWN FOX. it JUMPS! is it ready? in A2, this returns The quick brown fox. It jumps! Is it ready?. The formula first lowercases the text, then examines its characters in order. It capitalizes character 1 and any non-space character whose previous non-space character is a sentence-ending mark. TEXTJOIN puts the processed characters back together.
This version uses LET, SEQUENCE, MAP, and LAMBDA, so it is intended for Microsoft 365. It ignores ordinary spaces when checking after punctuation, but it is not a full grammar-aware sentence parser. For example, it may capitalize after an abbreviation such as etc., and it does not handle every punctuation pattern involving quotation marks, tabs, or line breaks. Treat its output as a starting point and check it when those details matter.
Examples and expected results
These examples show when each approach is appropriate. In every case, the source text is in A2 and the formula is placed in another cell:
- One sentence, all caps: EXCEL MAKES THIS EASY becomes Excel makes this easy with the basic formula.
- Mixed capitalization: tHis is A SAMPLE becomes This is a sample with the basic formula.
- Two sentences: this is one. this is two. becomes This is one. this is two. with the basic formula, but This is one. This is two. with the Microsoft 365 formula.
- A name or acronym: JANE VISITED NASA becomes Jane visited nasa. You must correct the intended capitalization, such as Jane visited NASA, yourself.
The difference in the third example is the key decision: if your cell contains only one sentence, the short formula is easier to understand and maintain. If it contains several sentences and you have Microsoft 365, the longer formula can handle common punctuation boundaries. Neither formula recognizes sentence meaning.
Common problems and limitations
Proper nouns and acronyms become lowercase. The LOWER function deliberately lowercases the rest of the text. That can alter names, product labels, initials, and abbreviations. Check the output before using it in a customer-facing document, report, or imported data set.
Leading spaces can hide the first letter. The basic formula uppercases the first character, not the first non-space character. If the source begins with spaces, remove or clean them first, or accept that the visible first letter may remain lowercase. Avoid assuming the formula trims or normalizes whitespace: it does not.
Sentence endings are not always periods. The multi-sentence formula looks for periods, exclamation marks, and question marks. It cannot determine whether a period ends a sentence or is part of an abbreviation or decimal, and it may make a capitalization choice that needs editing. It also only skips ordinary spaces between punctuation and the next character.
A formula does not overwrite its input. It displays a calculated result in the formula cell. If you need a fixed text result, copy the formula results and use Paste Special > Values to replace or populate cells. Keep a copy of the source data first, especially when converting a large range.
Blank inputs and errors behave differently. A blank A2 produces a blank result with the basic formula. If the source cell contains an Excel error, the formula will generally pass that error through rather than convert it to text. Correct the source error if you need a text output.
Fill the formula down and keep the results
For a list in A2:A100, put the formula in B2 and copy it down. You can drag the fill handle at the lower-right corner of B2, or double-click it when the adjacent column has continuous data. The relative reference changes from A2 to A3, A4, and so on. For a structured Excel Table, entering the formula in a new table column typically fills the calculated column automatically.
When the output is correct and you want text rather than formulas, copy the result cells. Select the destination, then choose Home > Paste > Paste Values. This replaces formulas with their displayed text values. On Windows, Ctrl+C copies; Ctrl+V opens the usual paste action, but use the Paste Values command to avoid retaining the formulas. On Mac, use Command+C to copy, then choose Paste Values from the paste options. Ribbon labels and available paste options can vary slightly by Excel build.
Keep the original column until you have checked the converted names, acronyms, and punctuation. If you paste values over the source column, the formula results become the replacement text and no longer update if the original source changes.
Other options for changing capitalization
For a quick, repeatable conversion, a worksheet formula is convenient because it updates when the source changes. Use the basic formula for a single sentence and the longer formula only when automatic capitalization after common sentence-ending punctuation is useful. The formula is not necessarily the best tool for every cleanup task.
- Manual editing: Best for a short list where names, acronyms, and sentence punctuation need careful judgment.
- Find and replace: Useful for replacing a known repeated text pattern, but it does not convert arbitrary text into sentence case.
- Power Query: Useful for repeatable data-import and transformation workflows. Review its available case transformations and the results; automatic case changes still cannot identify every proper noun or sentence boundary.
- VBA or an add-in: May suit a recurring workflow with special rules, but adds maintenance and security considerations. A custom routine still needs clearly defined rules for abbreviations, names, and punctuation.
PROPER is another built-in function, but it capitalizes the first letter of each word and lowercases the rest. For example, it can turn a phrase into title-style capitalization rather than sentence case. Choose it only when that word-by-word pattern is what you want.
Frequently Asked Questions
Does Excel have a sentence case function?
No. Excel does not provide a built-in SENTENCECASE worksheet function. Use a formula to change case, and review the result for proper nouns, acronyms, and sentence-boundary exceptions.
What is the simplest formula for sentence case in Excel?
With the source text in A2, use =UPPER(LEFT(A2,1))&LOWER(MID(A2,2,LEN(A2))). It capitalizes the first character and lowercases the rest of the cell.
How do I capitalize every sentence in a cell?
With text in A2, use the Microsoft 365 formula in this article. It capitalizes after periods, question marks, and exclamation marks when the next character follows ordinary spaces. Check abbreviations and unusual punctuation manually.
Will the formula keep names and acronyms correctly capitalized?
Not reliably. Lowercasing the remainder can change names and acronyms, such as NASA or McDonald’s. Review the output and restore any capitalization that should be preserved.
How do I replace the original text with the result?
Copy the formula results, then use Home > Paste > Paste Values in the destination. Keep an untouched copy of the source until you have checked the converted text.
Related
- Excel Accounting Solver: What It Does and How to Use It
- Excel Budget Spreadsheet Free? Find Templates and Tips
- Excel Accounting Format: How It Works and When to Use It Properly
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Formulas & functions
- Power Query Sort: How to Sort and Keep Rows in OrderTo sort data in Power Query in Excel for Microsoft 365 on Windows, open the query, select the…
- Excel INDEX MATCH Examples and How to Use ThemIn Excel, INDEX MATCH looks up a value by finding its position with MATCH and returning the value…
- Excel Time Difference in Hours: Formulas and ExamplesTo calculate the difference between two Excel times in decimal hours, subtract the start time from the end…
- SUMIFS Excel Less Than: Criteria and ExamplesTo sum values in Excel only when a related value is less than a limit, use SUMIFS with…
- Excel Time Math: Formulas for Adding and Subtracting HoursExcel time math treats times as fractions of a 24-hour day: subtract an earlier time from a later…
- VLOOKUP and XLOOKUP Examples: Formulas and Tips in ExcelFor an exact match, use VLOOKUP when the value you are searching for is in the first column…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.