View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Fish''s Mermaid Fish''s Mermaid is offline
external usenet poster
 
Posts: 3
Default Change from mixed caps and upper lower to all upper lower case

I have ever changing data base that imports as both mixed upper/lower and all
caps. I want to change all text to initial caps. Any formula in EXCEL to do
this?