# PROPER

## Content

This function capitalizes the first letter in each word of a text string.

## Syntax

`PROPER(text)`

## Arguments

The text argument can be a string, a formula that returns a string, or a reference to a cell containing a string.

## Remarks

This function capitalizes letters that follow any character other than a letter, for example, a space. This function converts all other letters to lowercase letters.

## Data Types

Accepts string data. Returns string data.

## Examples

`PROPER(D2)`
`PROPER(""INTRO to SPREAD"")` gives the result Intro To Spread
`PROPER(""Tom's one-time order"")` gives the result Tom’S One-Time Order