# PROPER

Spread for WinForms provides advanced software components that support Excel import/export, full cell customization, an extensive calculation engine with over 450 functions and more, all with zero dependencies on Excel.

## 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

## Version Available

This function is available in product version 1.0 or later.

## See Also

[CHAR](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsAtoC/FunctionCHAR) \| [UPPER](/spreadnet/docs/latest/online-formula/formulas-functionsall/formulas-functsTtoZ/FunctionUPPER) \| [Text Functions](/spreadnet/docs/latest/online-formula/formulas-overview/formulas-functs/formulas-functtypes/formulas-functstext)