Convert all text to UPPERCASE in a Google Spreadsheet

Question

I have a spreadsheet I'm sharing with others to collect some data. Each person is just (supposed to be) putting a single character in any of a range of cells.

How can I cause those cells to convert to uppercase?

Using =UPPER() in each cell would seem to be a non-starter, because it'll be overwritten by whatever they enter.

Answer 1

Here is a script that automatically converts input to upper case:

function onEdit(e) {
  if (typeof e.value != 'object') {
    e.range.setValue(e.value.toUpperCase());
  }
}

From the spreadsheet, go Tools > Script Editor. Put the above code in the code window (replacing anything pre-filled there), and save.

---

If you wanted to enforce upper case and single-character entries, then data validation could be used, with custom formula

=regexmatch(A1,"^[A-Z]$")

This is assuming the upper left corner of the range is A1, and that you expect letters of Latin alphabet. The regular expression ^[A-Z]$ means: beginning of string; single character in the range A-Z; end of string.

Answer 2

This is What you want.

Just change this line in the script...

ui.createMenu('Custom Menu')

...to this...

ui.createMenu('Case Change')

... for your own sake.