Proper Function in Excel

by | Dec 27, 2023

Function: PROPER

Excel, a powerful spreadsheet software, offers a range of functions to enhance data manipulation and presentation. One such versatile tool is the PROPER function, a valuable asset for text formatting within an Excel workbook. The PROPER function adeptly capitalizes the initial letter of each word while converting the remaining letters to lowercase. In this comprehensive guide, we'll explore the intricacies of the Excel PROPER function, providing insights, examples, and tips to optimize your proficiency in text manipulation.

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"

Mastering the Excel PROPER function opens the door to refined text presentation within your workbooks. Whether you're dealing with strings, references, or complex formulas, the PROPER function ensures a polished and consistent appearance. With this guide, you're well-equipped to transform your data presentation and streamline your Excel experience.