Purge functions leaving only calculated data?

  • Thread starter Thread starter kincaid05
  • Start date Start date
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.
 
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.
 
I figured it out. I saved the it as a .txt file first, then re opene
it
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

using the =page! feature to transpose a row to column 0
Importing Access DB into Excel changes my calculated fields in Exc 3
Annual leave monthly calculation 2
calculation taking too long 7
Calculation Time 2
Calculating time for 3rd shift 4
Counting # of Formulas in a column with formulas and entered data 1
Time Calculation 9

Back
Top