Formula Reference
Contacting Us
Getting Technical Support
Formula Overview
Formula Functions
- Functions A to C
- Functions D to G
- Functions H to L
- Functions M to Q
  - MAKEARRAY
  - MAP
  - MATCH
  - MAX
  - MAXA
  - MAXIFS
  - MDETERM
  - MDURATION
  - MEDIAN
  - MID
  - MIDB
  - MIN
  - MINA
  - MINIFS
  - MINUTE
  - MINVERSE
  - MIRR
  - MMULT
  - MOD
  - MODE
  - MODE.MULT
  - MODE.SNGL
  - MONTH
  - MONTHSPARKLINE
  - MROUND
  - MULTINOMIAL
  - MUNIT
  - N
  - NA
  - NEGBINOM.DIST
  - NEGBINOMDIST
  - NETWORKDAYS
  - NETWORKDAYS.INTL
  - NOMINAL
  - NORM.DIST
  - NORM.INV
  - NORM.S.DIST
  - NORM.S.INV
  - NORMDIST
  - NORMINV
  - NORMSDIST
  - NORMSINV
  - NOT
  - NOW
  - NPER
  - NPV
  - NUMBERVALUE
  - OCT2BIN
  - OCT2DEC
  - OCT2HEX
  - ODD
  - ODDFPRICE
  - ODDFYIELD
  - ODDLPRICE
  - ODDLYIELD
  - OFFSET
  - OR
  - PARETOSPARKLINE
  - PDURATION
  - PEARSON
  - PERCENTILE
  - PERCENTILE.EXC
  - PERCENTILE.INC
  - PERCENTRANK
  - PERCENTRANK.EXC
  - PERCENTRANK.INC
  - PERMUT
  - PERMUTATIONA
  - PHI
  - PI
  - PIESPARKLINE
  - PMT
  - POISSON
  - POISSON.DIST
  - POWER
  - PPMT
  - PRICE
  - PRICEDISC
  - PRICEMAT
  - PROB
  - PRODUCT
  - PROPER
  - PV
  - QUARTILE
  - QUARTILE.EXC
  - QUARTILE.INC
  - QUOTIENT
- Functions R to S
- Functions T to Z

PROPER

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.