Aims:
- replace £ ➜ space (del £)
- replace # ➜ £
I am going to convert the hex code to string however, it got some trouble.
The # (Hex: 23) converted into Â, £(C382 C2A3). The  is not expected to appear.
- £ read as £ and won’t del £
- Â,(C382) is extra
- Seems that sth wrong with oldCC.replace(beforeSymbol, afterSymbol)
db:
I search on internet using ChrW(CInt("&H" & xxx)) can convert Hex to ASCII. I saw the windows-1252 encoding can convert C2A3 to £ correctly. However, I didn’t find code can convert Hex to windows-1252 encoding. Is there any method can exactly convert C2A3 to £?
Now using:
Target result:
1