In Microsoft Excel, spilled array formulas cannot spill into merged cells. Unmerge the cells, or move the formula to another range that does not interconnect with merged cells.

Learn how to remove formula in Excel and keep the text. Use Paste Special option to delete formulas without removing values in Excel.

Microsoft Excel's new dynamic array functions make complex calculations easier than ever before.