1. Select the range of cells containing the formulas and press Ctrl+H or
select Home -> Find & Select (in Editing Group) -> Replace to open Find & Replace dialog box.
2. In the Find what box, type the equal (=) symbol.
3. In the Replace with box, type the # symbol (to change the formulas to text).
4. Click Replace All, and then click Close.
5. Copy and paste the cells to a new location.
6. Repeat steps 1 through 3 while reversing the # and = symbols (to change the text to formulas).