Change all text on Spread sheet

D

Daniel

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
 
D

Daniel

Ron

Thank you so much, this worked exactly as I needed and so much better than I expected, I will be saving this advice for future use.

Regards

Daniel
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top