Change the case of text in excel | Using Formula | Using Macro | Skills4All
Hi guys, today we will learn how we can change the case of text in excel sheet. Here we will discuss two methods to change the case of text: 1. by using formula and 2. by using macros . First we can add formula to our Excel sheet to change case of text. To change the text to uppercase, we will use the upper function =UPPER(cell ref) and will give the reference of the cell in argument to whom we want to change the case. Secondly, if you want to change the case of your text to lowercase then use the formula lower =LOWER(cell ref) and give the reference of cell as an argument. Similarly if you want to change your text to proper case, means only 1st letter will be capitalized, just use proper formula =PROPER (cell ref) and pass the cell reference as an argument. And now you can see the case will be changed as you will press enter. you can use fill handle to copy the formula in lower cells as well. Important thing is that if you remove the data from the cells that you have given as a