The PROPER function capitalizes the first letter in each word of a text value.

PROPER takes 1 required argument and no optional arguments:

Syntax: PROPER(text)

Using the PROPER function:
The arguments for the PROPER function are:
Argument Required? Description
text Required A text string enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize.


The PROPER function converts the first letter of each word in a text string to uppercase. A handy function that can produce some undesired results.
comments powered by Disqus