Capitalizing Spreadsheets

[Dave]

I'm trying to automatically Capitalize each word entered
on a spreadsheet, Any ideas out there?
Thank You

 

[J.E. McGimpsey]

You could have easily found this in the archives:

http://google.com/advanced_group_search?q=group:*excel*

but take a look at David McRitchie's Proper macro:

http://www.mvps.org/dmcritchie/excel/proper.htm