Is Change Case available in Excel for the option of Sentence Case?

I don't have a problem with upper case, lower case and proper case,,

My question is about sentence case which makes the first letter of a sentence capital and the rest are small letters.

2 Answers

  • 8 months ago

    I have never seen that in Excel.  It is available in Word but not Excel, as far as I know.  I suppose you could write yourself a macro to do it, if you wanted.

  • Bill B
    Lv 6
    8 months ago

    Yes, but it has to be performed using a formula. 

    To create a formula for sentence case we need to use five different text functions. Let's say your text is in cell A1, then the formula in B1 will be:


    EDIT to your comment:  Changing to Sentence case in Excel is not something Microsoft contemplated so a formula is the only way to do it. 

Still have questions? Get answers by asking now.