My original post in the SugarCRM forums was titled 5.1 Contacts export file shows email1 column twice but with invalid data.
I had not looked at this for some time but it raised its head again this week and I noted that while I had issued a bug report and it has been assigned, it will not be deployed until v5.5. so I’ll need to keep making the manual changes in the various v5.1/v5.2 sites that I manage.