Try preformatting the destination range as Text. Since some of the data has a letter in it then all of the data can be text, or is that a problem?