You can use the PROPER function to change the text from lower case or upper case to Proper case. In other words, using the PROPER Function you can change your text in the cell into starting alphabet as capital and all the rest into small.
For example, if you have your text in abc or ABC format we can change it to Abc format using PROPER Function.
Honoring our reader’s request related to learning Excel Functions, an initiative to simplify the learning we have added the infographics. This is a step by step process to for learning excel functions easily.
It is a very useful tool in Data management. It is very easy to use.
Excel consists of many inbuilt functions which help us simply our work and save time.
Let’s see how it works.
Syntax for PROPER Function
In the above Syntax just put the function along with your cell address and you get the result.
For example, if we have 3 names all are written in non-capital letters, simply applying the =PROPER(A2) formula in cell B2 we can change the text from lower case or Upper case to Proper case.
As shown in the featured image, all the names which are in capital letters or small letters are changed to proper case.
Similarly, you can also get the text in Upper case or Lower case using UPPER and LOWER functions.
We thank our readers for liking, sharing and following us on different social media platforms, especially Facebook.
If you have any queries related to Excel and Accounting please comment below, I will be more than happy to assist you.