Replacing Formulas

[Bob]

I am redoing a spreadsheet with several pages. In each page the cells
refer to a sheet that contains a master list of items. THus in the
cells it shows the item but really is a formula for the item to be
retrieved from the master list. I would like to delete the master
list. My question is: How do I get the items on each sheet to not
become blank when I do so? Do I have to retype the items or is there
some way of eliminating the formula and replacing it with the item
name?

I hope I have made myself clear. Thanks for any help.

Bob

 

[DDM]

Bob, select the cells, then Edit > Copy > Edit > Paste Special > Values >OK.

 

[Max]

Maybe try a copy > paste special > values "in-place" ?
This will convert the formulas to values

Let's say col A is one column which you want to convert all formulas therein
to values

Right-click on col A > Copy
Right-click again on col A > Paste special > Values > OK