Purge functions leaving only calculated data?

K

kincaid05

I'm trying to convert a spreadsheet so that I can import it into a SQL
server. It has alot of extra columns that were only used to make
calculations on the sheet. Is there anyway I can finalize a sheet,
deleteing all the formulas and leaving only the values that were
calculated for that cell.

The problem is as I start deleting columns I start getting #REF's
popping up cause data is missing. Any help or suggestions are
apreciated, Thanks.
 
D

Dave R.

Yes. You can press CTRL-A to select all cells from the worksheet. Then
CTRL-C to copy, then edit>paste special>values. The formats will stay the
same but the formulas will be replaced with values.
 
Top