View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Kathy[_3_] Kathy[_3_] is offline
external usenet poster
 
Posts: 4
Default Need to Change Case from Mixed to Caps

Please help! I have a number of imported worksheets with some fields
formatted in mixed case and some in UPPER case. I want all data to look
consistent.

Is there a way that I can quickly turn all of the mixed case to upper case?
Word has a button to do this but I don't see one in Excel.

Thanks in advance.