Hello all,

I've read this site without registering for some time, but now I have a question and am hoping someone can help me.

I have a book that has thousands of names all in ALL CAPS, and I was wondering if there was a way to convert them all to Proper Case? I also seem to be having trouble converting them one at a time using the =Proper formula.

Any thoughts.
Much appreciated.
RS