Inclusion of special characters while saving or downloading as a csv

pradeepvatsvk
New Contributor III

Hi All, I have data which looks like this High Corona40% 50cl Pm £13.29  but when saving it as a csv it is getting converted into High Corona40% 50cl Pm £13.29    . wherever we have the euro sign . I thing to note here is while displaying the data it is fine. I have tried multiple ways like specifying the encoding as utf-8 but nothing is working as of now