That's why, if you have to work in a CSV file, it's best to have a dedicated tool. ModernCSV, an indie app for Linux, Mac, and Windows computers, is the best tool I've come across for this purpose.