Also, make sure you add the class "mktNoTrack" so that it doesn't popup a re-direct window. You probably just want it to bring up the compose email window. The only side effect is ...
It's actually just an issue with excel. You can fix it in two seconds:
Select the entire column.
Go to Data > Text to Columns.
Choose "Fixed width."
Remove all break lines....
You don't even need that, this can be done from Excel itself. Just right-click the cells and choose "Format Cells," then pick the formatting you'd like.
If you right-click on your test and choose "Send Sample Test" you can enter your own email address and it will send you both the champion and challenger!
1. If it is a subject line test, then it will pull the existing subject into the test to be the "champion" you are validating. You would then specify another subject to use as the ...