PROPER
Capitalizes the first letter in each word of a text value
Syntax
PROPER(text)
Parameters
- text: Required. Text enclosed in quotation marks, a formula that returns text, or a reference to a cell containing the text you want to partially capitalize
Example
=PROPER("this is a TITLE")