You need to use a formula based on the PROPER function to achieve itJust like this. UPPER A2 and hit the enter key. For making cell text uppercase please enter the formula UPPER B2 into the formula bar and then press the Enter key.
Click on the letter on the top of the text column.
Click on the cell where you wish to get the capitalized version of cell A2. PROPER A1 into a blank cell C1 for instance where you want to get the result see screenshot. 10 Easy Steps Step 1 Select the text data which you want to convert in the upper case in excel. PROPER text The variable text can refer to a cell address or to a statically declared string.