When I export data froma report data list, and the value in a field has an "&" instead of the word "and" and/or an apostrophe, the value exported shows up with "&" or "'" respectively.
For example: the field Book Title contains "The Lion, the Witch & the Wardrobe". When this is exported it shows up as "The Lion, the Witch & the Wardrobe".
Another example: the field Last Name contains "O'Malley", but it is exported as "O''Malley".
Why is this happening?
