View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
HKaplan HKaplan is offline
external usenet poster
 
Posts: 80
Default Take off CAPS on an entire spreadsheet

You can add a column next to the columns with the caps and use
=Proper(A1) for instance to change to proper case for the entry in
A1. I don't know of a way to change a whole spreadsheet in one
command.