How to use the PROPER Function in Excel

Description

The PROPER Function is categorized as Text Function in Excel. This function converts the first character of each word in given text strings to uppercase and rest of the text converted to lowercase. It do not affect the punctuation, spaces, special characters. But it will convert number as text and it will remove all number format.

The PROPER function takes one argument which can be a text string or any cell reference. It can also be used as a part of a formula. We can use this formula to organize large volume of text.

Syntax

The syntax of PROPER function is =PROPER(text)

Argument or Parameter

text- can be a text string or cell reference which we want it to be in lowercase text.

Returns

The PROPER returns text strings, where first character of each word get capitalized and rest of the character are in lowercase. Standalone number will lost their number format.

Example

Example-1

We have provided different types data which contains text having text string in uppercase, lowercase. Numbers with different number format. We have also added punctuation and special character. All the data are in A column and we lower function is used column B, we can see the results in column B. See the image below.

Example-2

Suppose we have imported external data in column A and column B. We can see the data in column is unorganized, different text are in different type case and we need to convert it into lowercase. So what we have to do is, select cell C2 and type =LOWER(B2 ) and press Enter. Then drag the fill handle of cell C2 till the last cell of the data. All the data will be converted to lower case at a time.

Notes

First character of each word get capitalized. Rest of the character will lowercase.
Special Character & Punctuation will be unaffected.
Formatting of standalone numeric value will be removed.
Letters just after any punctuation or special character will be capitalized.

********************************* ~:Support Our Work Financially:~ *********************************

Project File Type: Free

If you think this tutorial helps you to solve your problem and add value to your work, Buy me a Coffee..

************************************************************************************************

TEXT FUNCTIONS FUNCTIONS
BAHTTEXT	CHAR	CLEAN	CODE	CONCATENATE
DOLLAR	EXACT	FIND	FIXED	LEFT
LEN	LOWER	MID	NUMBERVALUE	PROPER
REPLACE	REPT	RIGHT	SEARCH	SUBSTITUTE
T	TEXT	TRIM	UNICHAR	UNICODE
UPPER	VALUE