Import Character Error
I have an input module with some line items formatted as a drop down lists.
My drop down list looks like this for each column
When I export this as a csv file, it comes out with a "Â" character beside the "£ numbers" this way below.
When I run an import using this same file to re-import to the input module. It works but fail for the (AG column) saying list item can not be located.
I'm wondering is it because of the "Â" character and if so why does it have no problem for column "AE" AND "AF" but has issue with column "AG"?.
Any suggestion on what to do or work around will be really helpful, thanks.