Using the PROPER Function in Excel: A Complete Guide

Rumman Ansari   Software Engineer   2024-08-03 03:00:25   152  Share
Subject Syllabus DetailsSubject Details
☰ TContent
☰Fullscreen

Table of Content:

PROPER Function in Excel

In Excel, the PROPER function is used to capitalize the first letter of each word in a text string, while converting all other letters to lowercase.

Here's the syntax of the PROPER function:


=PROPER(text)

where text is the text string you want to convert.

For example, if you have a cell with the text "the quick brown FOX jumps OVER the LAZY dog", you can use the PROPER function to capitalize the first letter of each word like this:

  1. Select the cell where you want to display the capitalized text.
  2. Type the PROPER formula: =PROPER(A1)
  3. Press Enter.

The cell will now display the text as "The Quick Brown Fox Jumps Over The Lazy Dog".

Note that the PROPER function doesn't change the original text in the cell, it only returns a new text string with the first letter of each word capitalized. If you want to replace the original text with the capitalized version, you'll need to copy and paste the new text into the cell.