Make cell contents lowercase to uppercase in Excel 2007

① start the Excel2007, open the table and see that the D column is all lowercase, we need to convert it to uppercase, enter the following function formula in the cell: =upper (D2).

② formula input complete, everybody remember, if in English half-width state input, enter, get results Soho China.

③ the mouse to the lower-right corner of the cell, with the + sign, and double-click to populate the entire data area.

Formula meaning

Upper (cells): Converts lowercase letters to uppercase letters.

Converts lowercase letters in cell D2 to uppercase letters.

Classification:

• Excel Tutorials