View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
klmiura klmiura is offline
external usenet poster
 
Posts: 34
Default Change first letter of every word to Capital

Does anyone have a Macro that I can use to change the first letter of every
word in an excel cell to Capital?

For example I have cell A1 with the contents of: private hospital

I would like to run the Macro and the cell to say: Private Hospital

Thank you,
Karen