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.
- 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.
- 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:
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.