Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Want to automatically change text case as I type on Google Sheets so that first letter of the sentence is capitalized.
here is a formula which can do so:
=IF(EXACT(LOWER(LEFT(A2, 1)), LEFT(A2)),
UPPER(LEFT(A2, 1))&MID(A2, 2, 999^99), A2)
otherwise, you would need some auto-correct chrome extension
Required, but never shown