& sign breaks some functions

Hi,

I’ve found a recurring problem. When users submit data that contains the ‘&’ character, some functions break. I’ve noticed that:

– Using the Mailchimp function will break: E-mail adresses may not be added to the list.
– Exports will have a potential problemetic bug: Exports opened in excel will have all data in a single column seperated by commas EXCEPT for data that contained an ‘&’. Data after this ‘&’ will be in a seperate column.

Working is:
– All information is e-mailed correctly, regardless of using ‘&’ or not.
– All information is stored correctly, regardless of using ‘&’ or not.

Would be great if we could get a fix for that. Took me a long time to actually track this problem down and can imagine many others missing contacts because of it without realising it!