PROPER Function in Excel
PROPER Function in Excel
In this video tutorial on PROPER Excel Function, we will see how to use the PROPER Formula in excel with the help of an example.
------------------------------------------------------------------------------------------------------------------------
What is the PROPER Function in Excel?
A proper function in excel is used when we have a string of text or a sentence that is not in a proper format. Using the Proper function here will convert that text into a proper case in which every word’s first letter will be in CAPS or Upper case, and the rest of the letter will be in Lower case. This function considers only text as input. For example, suppose we have a text like “this is a bat,” then use a proper function. In that case, it will change its format to “This Is A Bat.”
--------------------------------------------------------------------------------------------------------------------
PROPER Formula in Excel
=PROPER(text)
----------------------------------------------------------------------------------------------------------------
Arguments:
Text: In the PROPER function, there is only one parameter which text; we can define it as it is the cell address for which the PROPER function will be used and converted into the first character in uppercase and the rest in lowercase for each word.
It is very much easy to use and used where the text is messed up due to many reasons.
-------------------------------------------------------------------------------------------------------------
To learn more about the PROPER Function in Excel, you can go to this link:
https://www.educba.com/proper-in-excel/
-------------------------------------------------------------------------------------------------------------
Connect with us!
Youtube ► / @educba_official
LinkedIn ► / admin
Facebook ► / educba.official
Instagram ►https://www.instagram.com/educba.offi...