On 2011 May 12, at 13:43, Sue wrote:

> Answering my own question...I used Replace with Proper (word)  as my equation to solve the problem!  Never noticed that function before--it actually does replace the value, not just the style.


I'm a big fan of the Proper function, but do note that it's going to give you results like
 • Gone With The Wind
 • Mccarthy
 • O'brien
 • Ipad
that you'll probably have to fiddle with manually.