Proper case option

[bkjohns]

Apologies if already requested (search didn't find it specifically): Under the Change Case option, could you please add a 'Proper' option that would capitalize each word, like names, titles of books/films, etc? Most programs seem to offer this so it should be easy to do.
Thanks

[gwpriester]

+1 I have never heard this term before but it is an excellent idea.

[bkjohns]

Comes from way back, but is still found in Excel. I always thought it was a useful option.

[ss-kalm]

I think what your referring to is also called "Title Case". In my opinion that would be a great addition.

[mwenz]

Proper casing is hard to do. And there are a few different standards at play. Words in a string consisting of and, the, and others shouldn't be in caps, for instance in most English casing situations. But other languages vary.

But the common casing of other applications would be a good start.

[Rob-Xar]

Hi bkjohns,

This option (labelled Initial Case) will be available in the next version (V16) when it comes out very soon.

Thanks
Rob

[bkjohns]

Proper casing is hard to do. And there are a few different standards at play. Words in a string consisting of and, the, and others shouldn't be in caps, for instance in most English casing situations. But other languages vary.

But the common casing of other applications would be a good start.

Agreed - some issues still remain in the latest version of Excel - so you just have to work around them, but overall I find it quicker than changing every letter in every word to upper or lower case and then editing to fit my needs one letter at a time. Maybe someday someone will figure out the programming to make it adjust to real life.