View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Roberson Roberson is offline
external usenet poster
 
Posts: 1
Default Auto change all caps to upper and lower case

I received a spreadsheet with 500 names that need to be merged into labels.
Entries are in all caps. Is there a way to convert names into proper upper
and lower case without re-entering them? Using 2003 XP.