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.