I made an array in a cell and hit ctrl, shift, enter. It works well. Now I drag that formula to 1000 other cells. But to turn on the array function I have to click on each one and hit Ctrl, shift, enter. Is there a way to make all of them work at once?

Chuck.