Exporting report in CSV adds extra space to field

Summary

CSV report adds a space to a field, which doesnt happen when report is exported via Excel.

Content

Hi,

 

I have one report which is automatically scheduled to be sent in CSV format every week. However, this report is for some reason exporting one location with an extra space. All our locations look like:

US - CHARLOTTE

US - CHICAGO

US - DALLAS

US - LA

US - MIAMI

US - NEW JERSEY

 

However, we have one value that comes out like 'US  -  New York' (with an extra space either side of the '-'). This is weird as when I export the file in excel it is fine, and in the system it is fine and in the correct format as every other location.