How to remove formula but keep the value data output - Excel
Click a cell in the array formula. On the Home tab, in the Editing group, click Find & Select, and then click Go To. Click Special. Click Current array.
Click a cell in the array formula. On the Home tab, in the Editing group, click Find & Select, and then click Go To. Click Special. Click Current array.
