Function: PROPER

by | Nov 12, 2018 | Excel Formulas

Function: PROPER

The PROPER function capitalizes the first letter of each word and converts the remaining letters into lowercase. In this guide, we’re going to show you how to use the this function and also go over some tips and error handling methods.

Supported versions

  • All Excel versions

Syntax

PROPER(text)

Arguments

text The text you want converted into a style where first letter of each word is capitalized, and the rest made lowercase.


Examples

Example 1

=PROPER("chArIzArd")
formula returns "Charizard" as text value.

PROPER Example 1

Example 2

=PROPER(Id&" - "&Name&" - "&Type)
formula returns "6 - Charizard - Fire, Flying". This function can convert strings from references and doesn't affect numbers, spaces, or punctuation.

PROPER Example 2

Download Workbook

Tips

  • Try UPPER function to convert strings into uppercase.
  • Try LOWER function to convert strings into uppercase.
  • The PROPER function can't recognize suffixes that are separated with a punctuation character. So, the function capitalize them as well. For example; =PROPER("Ash's Pikachu") returns "Ash'S Pikachu"