View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jacqueline Jacqueline is offline
external usenet poster
 
Posts: 17
Default convert text to sentence case

Is there a way to convert all cap text to sentence case in Excel. I have to
dump data from one database into an Excel spreadsheet, where the data is
scrubed and then appended to a table in another database.

The data comes from the first database in all caps! Any help is greatly
appreciated.
Thanks

--
Jacqueline