| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Purge functions leaving only calculated data?
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. -- kincaid05 ------------------------------------------------------------------------ kincaid05's Profile: http://www.excelforum.com/member.php...o&userid=25232 View this thread: http://www.excelforum.com/showthread...hreadid=387197 |
|
#2
|
|||
|
|||
|
Yes. You can press CTRL-A to select all cells from the worksheet. Then
CTRL-C to copy, then editpaste specialvalues. The formats will stay the same but the formulas will be replaced with values. "kincaid05" wrote in message ... 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. -- kincaid05 ------------------------------------------------------------------------ kincaid05's Profile: http://www.excelforum.com/member.php...o&userid=25232 View this thread: http://www.excelforum.com/showthread...hreadid=387197 |
|
#3
|
|||
|
|||
|
I figured it out. I saved the it as a .txt file first, then re opened it. -- kincaid05 ------------------------------------------------------------------------ kincaid05's Profile: http://www.excelforum.com/member.php...o&userid=25232 View this thread: http://www.excelforum.com/showthread...hreadid=387197 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is the order of my data table opposite from graph? | Charts and Charting in Excel | |||
| Losing data on copy and paste functions | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Help making a chart that doesn't graph cells without data? | Excel Discussion (Misc queries) | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
Linear Mode
