It looks like some of the other answers have become outdated, but for me this worked:
- Click on the cell with the text/formula to copy
- Shift+Click on the last cell to copy to
- Ctrl + Enter (Cmd + Enter on Mac.)
(Note that this replaces text if the destination cells aren’t empty)