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 ...

Stop manually inserting rows and columns—use Excel's "secret" right-click-drag menu to move, swap, and convert data instantly ...