Quote:
Originally Posted by Bristolduke
The way I do it is to backup the csv.
1. Make a copy of the csv.(rename as something)
2. Make whatever changes I want to make to the copy.
3. Open the original csv
4. Copy the column on the copy csv that is the data I'm changing
5. Paste Values on the column in the original csv
6. Close the original csv It then asks if I want to save the changes, and then if I want to save as csv.
|
Do you do all of this in Excel? What version of Excel do you use? Because even making *no* changes this fails with Excel for me, Excel 2008 I think.