"Louise" wrote in message
...
Hi all

I can't believe I can't remember how to do this but how do you change text
in Excel from upper case to sentence case? I have a workbook with approx.
15
worksheets and everything is in upper case and needs changing.

Thank you.
Louise

Excel offers only -
=lower(a1)
=upper(a1)
=proper(a1) (which capitalises everything)

The only way I have found to change to 'sentence case' is to -
copy and paste into Word
use <Format<Change Case<Sentence Case
copy and past back into Excel

This may be a bit tedious and there may be other ways but it works!

Bill Ridgeway
Computer Solutions