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

Relevance
  • 2 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.

    • Log in to reply to the answers
  • Bill B
    Lv 6
    2 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:

    =UPPER(LEFT(A1,1))&LOWER(RIGHT(A1,LEN(A1)-1))

    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. 

    • Honest2 months agoReport

      Thanks for the formula, but I thought there should be an easier way.

    • Log in to reply to the answers
Still have questions? Get answers by asking now.