THANK YOU both so much. A combo of using Ctrl Enter and then using the autofill handle in the bottom right corner of the cell seems to have done the trick.
You have both saved me a lot of time wasting and cursing my ex colleague!