Change text to Upper case
If you need to convert text to all Upper case use UPPER().
This assumes your text to change is in cell A1:
1. In cell B1 type =UPPER(
2. Select cell A1 then hit Enter.
3. To get this text back in the original cell, use Paste Special and delete the helper cell B1.