import - Converting special characters from csv to csv UTF-8

Question

I've just tried converting my "normal" csv (produced by MS Excel when saving an xls just as ordinary csv) into csv UTF-8 using the "Convert to UTF-8" feature of Notepad++ as explained here: How to convert csv files encoding to utf-8

One problem is that the british pound sign (￡), which is originally encoded in my csv as A3, got converted into D088 and so is showing up as "J" now. The following link tells me that it should be C2A3 instead and manually changing D088 to C2A3 fixes it indeed: http://unicode.org/mail-arch/unicode-ml/y2009-m06/0069.html

Is it a Notepad++ issue by chance? Is there perhaps any other way of converting it properly, so there's no need to fix anything like that afterwards? My MS Excel has no "Save as csv UTF-8" option.

Many thanks in advance!

Answer 1

等待大神答复