A nice quick tip, I had lots of cell values in a mixture of cases that should have been uppercase.
Create a macro:
for each myCell in Selection
myCell.Value = UCase(myCell.value)
Add a menu item to your toolbar and then assign this macro to it.
Select the cells you want to upper case then press the button!