PROPER Function in Excel Step 1. All letters in text will be converted to lower case before the first letter in each word is capitalized. We get the results below.
If you want apply the formula to an entire row you can select the entire row first.
Below is the picture for reference. There we can search for anything we want. IFA1 100 A1 5 A1 7. This process activates all the functions or formulas of excel.