3 ms·
The thing that I always find frustrating about using spreadsheets (well, Excel) is that it's difficult to prevent unwanted invisible characters and automatic ty
by perl4ever 7y ago
The thing that I always find frustrating about using spreadsheets (well, Excel) is that it's difficult to prevent unwanted invisible characters and automatic type/format changes from wreaking havoc. I generally resort to exporting to text and using regular expressions to clean spreadsheets that I'm given.
You can do a remarkable amount with MS Access and VBA though.