ƒxPlainFormulaThink in English. Formula in Excel.

FUNCTION CATALOGUE / TEXT

PROPER Excel function

Capitalises words in text.

Correct sentence to use

Capitalise each word in [text].

Modify this query in PlainFormula →

Example formula

=PROPER(A2)

Capitalises the first letter of each word.

Syntax

PROPER(text)

Argument signature: text

Availability note

Commonly available in current Excel; verify platform and locale-specific behaviour.

Check Microsoft's Excel function documentation ↗

← Browse all functions