Thread: How can I use one formula to change case on an entire worksheet?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Martin
 
Posts: n/a
Default How can I use one formula to change case on an entire worksheet?
If the names are in a column, create a Proper function in a new column beside
it and copy it down. The copy the new column and paste values back over the
original.

"pow835" wrote:

I inherited a worksheet where some of the names are typed on all caps. Is
there an easy way to change the case on those cells without selecting each
cell individually and using the PROPER function?
Reply With QuoteReply With Quote