Well, as long as you don't mind manually propagating the formula in one direction, just go to a cell you want, highlight the text out of the formula box up top and hit ctrl-c, it does a text copy. Go ...

By combining To Go Special with Ctrl+Enter, you can fill thousands of empty cells with the correct data in seconds. First, ...