So no matter letters are entered in uppercase or. Changing Text to Uppercase Using the UPPER Function To change the case of these names to uppercase we would simply use the UPPER function. PROPER text The variable text can refer to a cell address or to a statically declared string.
Use UPPER A2 in cases where you need to convert text to uppercase replacing A2 with the appropriate cell reference.
This formula converts the name in cell A2 from uppercase to proper case. Converting the text in column to UPPER case characters myColumnUPPERtotal. In cell B2 type PROPER A2 then press Enter. Changing Text to Uppercase Using the UPPER Function To change the case of these names to uppercase we would simply use the UPPER function.