Hi All--

I found and appended this Word macro to convert to Proper (Title) Case, without capitalizing prepositions. It works like a charm in Word but I really would love to somehow tailor it to work in Excel. I know that there's not an equivalent of .find but I'm not sure if the split/array can be similarly utilized rather than 50 or more search/replaces. Please realize much of this code still retains the original Word VBA. Thanks!

Please Login or Register  to view this content.