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

As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...