Skip to content

PROPER

TextExcel 2007

Capitalise the first letter of each word.

Syntax

PROPER(text)

Examples

=PROPER("priya sharma")

→ Priya Sharma

Good to know

  • It also capitalises after any non-letter, so "o'brien" → "O'Brien" and "3rd" → "3Rd".

Related functions

UPPERLOWER

More Text functions

ARRAYTOTEXTASCBAHTTEXTCHARCLEANCODECONCATCONCATENATEDBCSDOLLAREXACTFIND

← All 510 functions

Syntax follows Microsoft’s documentation. Examples are written to be pasted into a cell and checked. Argument separators may be ; in your locale. The AI explainer runs on a free community model — verify anything important.