Text
Capitalize only the first letter of a cell (sentence case)
Capitalize the first character and lowercase the rest of a short text label; preserve empty inputs with a blank guard.
Sentence case vs PROPER title case
Spreadsheets provide UPPER, LOWER, and PROPER, but no SENTENCECASE function. PROPER("urgent SHIPMENT for client") capitalizes every word ("Urgent Shipment For Client").
Splitting the trimmed string into UPPER(LEFT(t, 1)) plus LOWER(MID(t, 2, LEN(t))) capitalizes only the very first character and lowercases the remainder.
This is first-character casing, not linguistic sentence detection. It does not capitalize after punctuation or preserve proper nouns. The examples use ordinary spaces; whitespace and Unicode casing can differ between products.
| RawHeadline (A) | Sentence Case | PROPER Case |
|---|---|---|
| urgent SHIPMENT for client | Urgent shipment for client | Urgent Shipment For Client |
| api token expired | Api token expired | Api Token Expired |
Sentence-case formula with LET and TRIM
Trimming first ensures a leading space is not treated as the "first character" while leaving the actual first letter lowercase.
=IF(COUNTBLANK(A2:A2)=1,"",LET(t, TRIM(A2), UPPER(LEFT(t, 1)) & LOWER(MID(t, 2, LEN(t)))))Preserve uppercase acronyms in the rest of the text
Drop LOWER(...) on the tail when you want to capitalize the opening letter without disturbing internal acronyms like "CSV" or "ERP".
=LET(t, TRIM("export CSV to ERP"), UPPER(LEFT(t, 1)) & MID(t, 2, LEN(t)))Try the example
Use the original values or change them to test your understanding.