All functions / Text

PROPER

Capitalises The First Letter Of Each Word.

Syntax

=PROPER(text)

Arguments

• text: The text (or a cell containing it).

Example

=PROPER("ada LOVELACE") → "Ada Lovelace"

Practise it

• Cleaning up messy text
• Repairing numbers and names