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.