Proper() function

The Microsoft Excel PROPER function sets the first character in each word to uppercase and the rest to lowercase.

Warning: as well as the first letter of every word, letters following numbers or other punctuation are converted to upper case by the Excel Proper function. This may be in places that you might not expect. For example, the function converts the "s" in the text string "Bob's Boat" to upper case (i.e. "Bob'S Boat").

Syntax

The syntax for the PROPER function in Microsoft Excel is:

PROPER( text )

Parameters or Arguments

text

The string argument whose first character in each word will be converted to uppercase and all remaining characters converted to lowercase.

Proper Function Examples

In the following spreadsheet, the Excel Proper function is used to convert four text strings to proper case:

Formulas:

	A	B
1	this is a test sentence	=PROPER( A1 )
2	THIS IS A TEST SENTENCE	=PROPER( A2 )
3	111tEST teXT	=PROPER( A3 )
4	Mr. SMITH's address	=PROPER( A4 )

Results:

	A	B
1	this is a test sentence	This Is A Test Sentence
2	THIS IS A TEST SENTENCE	This Is A Test Sentence
3	111tEST teXT	111Test Text
4	Mr. SMITH's address	Mr. Smith'S Address

  

Reference:

http://www.excelfunctions.net/Excel-Proper-Function.html

https://www.techonthenet.com/excel/formulas/proper.php

follow us on http://arivilm.blogspot.in

like us on https://www.facebook.com/Arivilm2501/