Change all text on Spread sheet

  • Thread starter Thread starter Daniel
  • Start date Start date
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
 
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
 
Back
Top