How to convert text to capital letters and more in Excel Often times computer users find it difficult to change case in Excel. Imagine working on a huge volume of excel data and you need to convert a record to capital letters or the reverse. Boom! your stuck because it is not word document. We all …
What is PROPER function in Excel? PROPER function is one of TEXT functions in Microsoft Excel that capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter. Converts all other letters to lowercase letters. Syntax of PROPER function PROPER(text) The PROPER function syntax has …
If you need to clean up names that are not in a proper case, you can use a simple formula based on PROPER functions. Formula =PROPER(name) Explanation In the example the formula in C5 is: =PROPER(B5) How this formula works The PROPER function automatically reformats text so that all words are capitalized. At the same …