## Trending News

# 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

- busterwasmycatLv 72 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.

- Login to reply the answers

- Bill BLv 62 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.

- Login to reply the answers