Answers.Body: <p>This should be solved in version 5.22. It's usually non-english characters where Excel needs a special header to be able to determine the encoding.</p>
  
  <p>See <a href="https://github.com/civicrm/civicrm-core/pull/16117" rel="nofollow noreferrer">https://github.com/civicrm/civicrm-core/pull/16117</a> and <a href="https://lab.civicrm.org/dev/core/issues/1424" rel="nofollow noreferrer">https://lab.civicrm.org/dev/core/issues/1424</a></p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2020-02-11T18:19:21.393Z
Answers.LastActivityDate: 2020-02-11T18:19:21.393Z
Answers.UserDisplayName: Demerit
Body: <p>How to get rid of Â when exporting report to CSV file. running report</p>
  
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-02-11T17:04:13.930Z
Comments.Text: Welcome to CiviCRM SE! I'm guessing that this is the same as I have seen and that the unwanted character precedes a current symbol (£ in my case). Its always good to give as much information as you can. Its always good to give the version of CiviCRM (though this has been like this for ages for me) and also what CRM you are using (may well be relevant).
Comments.UserDisplayName: Mick Kahn
Comments.ContentLicense: CC BY-SA 4.0
Comments.CreationDate: 2020-02-11T17:28:17.303Z
Comments.Text: Just tried it on the WordPress demo site and I didn't get the problem! So I'm wondering if its something to do with the character encoding settings on my site.
Comments.UserDisplayName: Mick Kahn
Tags: <civireport>
Title: How to get rid of Â when exporting report to CSV file
ThreadText: # How to get rid of Â when exporting report to CSV file
  
  (Asked by: username_0 on 2020-02-11)
  
  How to get rid of Â when exporting report to CSV file. running report
  
  **Tags:** civireport
  
  > **Comments:**
  > **username_1**: Welcome to CiviCRM SE! I'm guessing that this is the same as I have seen and that the unwanted character precedes a current symbol (£ in my case). Its always good to give as much information as you can. Its always good to give the version of CiviCRM (though this has been like this for ages for me) and also what CRM you are using (may well be relevant).  
  > **username_1**: Just tried it on the WordPress demo site and I didn't get the problem! So I'm wondering if its something to do with the character encoding settings on my site.  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_2 on 2020-02-11. Score: 2
  
  This should be solved in version 5.22. It's usually non-english characters where Excel needs a special header to be able to determine the encoding.
  
  See <https://github.com/civicrm/civicrm-core/pull/16117> and <https://lab.civicrm.org/dev/core/issues/1424>
  
  
  ---
  
  