Skip to content

How to Use Excel PROPER Function?

Ads
Listen to this article.
Proper casePin
Proper case

Proper Function in Excel: Excel is one of the popular spreadsheet programs that provide various formulas and functions for performing mathematical calculations with a few clicks. Usually, we enter data in alphabets or numeric values on the spreadsheet. In case, we mixed up the small and capital letters while inserting data in the worksheet, what will we do to fix it and change it into a proper case? Don’t panic. It is pretty simple.

We suggest you use the PROPER Function in the Excel worksheet in order to apply the proper text case to your data. This article gives you an illustration of the explanation, syntax, and usage of the Proper function in Excel. Get the official version of MS Excel from the following link:

https://www.microsoft.com/en-in/microsoft-365/excel

Excel PROPER FunctionPin
Excel PROPER Function

Description of PROPER Function

  • It is one of the built-in functions in Microsoft Excel.
  • The Excel PROPER function will capitalize the first letter in each word.
  • In this function, all the letters in the given text string will be converted to lower case except the first letter in each word. Because, it capitalizes the first letter in each word.
  • Numbers, punctuation, and spaces will not be affected by this function.

Syntax

  • Here, you will see the syntax of the PROPER function.
  • To apply this function on your spreadsheet, you have to select a cell and enter the formula in the following format.
  • Once you enter the formula, just click on the Enter button to get the result.

=PROPER(text)

Argument Description

  • Text – The input text that will be converted into a proper case.

Practical Examples

Now Let’s grasp some examples of the PROPER function and explore how it works in Microsoft Excel.

  • Initially, you have to open your Excel workbook on your PC and launch a worksheet that has data.
  • For example, we have given the input text string in Cell B3, as shown in the below screenshot.
InputPin
Input
  • Then, we have to apply the above-mentioned formula and hit the Enter button in order to get the result.
Apply the formulaPin
Apply the formula
  • Once you have executed the formula, you will get the result, as shown in the following screenshot.
ResultPin
Result
  • Let’s see some more examples for your understanding. In the following image, you will see the input text strings in the range B3:B6.
  • Then, we applied the PROPER function to this range and get the result.
PROPER CasePin
PROPER Case

Closure

By reading this article, you can get some clarification about the explanation, syntax, and usage of the Proper Function with a few practical examples. Don’t forget to drop your worthwhile Feedback. To learn more about Excel functions, then visit our webpage¬†Aawexcel.com.

Video Tutorial

Refer to the below video to understand how to use the PROPER function in Excel.

Related Articles:

Tags:

Leave a Reply

Your email address will not be published. Required fields are marked *

Share to...