Thread: Change entire column in spreadsheet from upper case
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default Change entire column in spreadsheet from upper case
=PROPER(A1)

HTH
--
AP

"JLS" a écrit dans le message de news:
...
imported excel spreadsheet has names in all caps. is there an easy way to
change these? for example John Smith instead of JOHN SMITH


Reply With QuoteReply With Quote