Hi

I have Excel 2007, I have a Spread sheet with a few hundred lines and six
columns, the sheet contains cells with
text and numbers, sometimes in the same cell but mostly in separate cells.

The text has all been entered in CAPS, and I need to alter it for better
appearance.

Is there some way I can automatically change the Caps to lower case but
leaving the first letter
on each word in caps?

All help appreciated.

Regards

Daniel