@NormalHuman: I like your script solution, but I have to admit I've never attached a script to a Google Spreadsheet before. Can you lend a hand?

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

This is all; you can simply close the script editor window then.

Perfect. Thanks.

(Too simple.)