I teach newbies , and we need to know if anyone has a way to format cells SO THAT WHEN THE TEXT IS TYPED in lowercase, for instance, it changes to Title Case, or UPPERCASE, or whatever, IN THAT CELL. (The Proper Fx only works in another cell, if you see what I mean.)
Caveat: we need a solution that can be used by newbies, without macros or VB, and without add-ins, because schools don't allow that. While I suspect there wouldn't be add-ins if this were easy, I have to ask.
Caveat: we need a solution that can be used by newbies, without macros or VB, and without add-ins, because schools don't allow that. While I suspect there wouldn't be add-ins if this were easy, I have to ask.