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 dynamic array function XLOOKUP() might completely replace VLOOKUP() and HLOOKUP().

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.