The Alt+Enter shortcut isn't limited to new formulas you write—you can go back and clean up any messy formulas at any time.
There are two ways to fix this cause of the #SPILL! error. First, select the entire spill range (or at least the cell or ...
Learn how Excel functions can act as data using LAMBDA, LET, and BYROW, so you reuse logic and cut formula edits.