PROPER
Convert text to title case.
Syntax
PROPER(text)| Argument | Required | Description |
|---|---|---|
text | Required | The text to convert. |
Examples
Every example below was executed against VisiGrid engine 0.35.0 — not
transcribed from another vendor's documentation. Reproduce any of them with vgrid calc.
| Formula | Result | Notes |
|---|---|---|
=PROPER("ana bo") | Ana Bo | |
=PROPER("ANA BO") | Ana Bo | Shouting input is lowered as well as capitalised. |
=PROPER(A1) | O'Brien | An apostrophe counts as a word boundary — usually right. |
=PROPER("jean-luc") | Jean-Luc |
It capitalises after any non-letter
That is right for jean-luc and o'brien, and wrong for macdonald, van der berg, and every product code with a digit in it. PROPER("iPhone") gives
Iphone.
So it is a cleanup for human names and addresses typed inconsistently, not a general formatter. For anything where the correct capitalisation is a fact about the value rather than a rule about the text, keep a lookup table.
Cleaning imported names
The usual pipeline is all three text-case functions doing one job each:
=PROPER(TRIM(A1))TRIM removes the padding an export left behind, PROPER
normalises the case. Doing it once in a helper column beats wrapping every
formula downstream.
Excel compatibility
Matches Excel, including capitalising after apostrophes and hyphens.