Something that would be able to

coNverT WeiRD caPS -> Convert Weird Caps


Welp found it. Read the docs.

The formulas are

=upper() =lower() =proper()

There is also this answer if you need something fancy because the cells will be overwritten. Convert all text to UPPERCASE in a Google Spreadsheet

But the formulas work great.


In the case Joshua Dance's answer above isn't clear enough,

  1. On an empty cell, type =proper(. (Yes, without the close-parenthesis)
  2. Click on the cell containing the text you want to change to Proper Case (a.k.a Title Case.)
  3. Hit Enter. (You'll see the result in the previously empty cell.)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.