You’re pasting like it’s 2005.

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

Not everyone is an Excel spreadsheet expert and you may not always know how to write the formulas you need for a given data set. If you're having trouble figuring out the right formula for your data ...