Just for more kicks can you attach the actual file you used for what is in row one of the Excel sheet. My suspicion is that it's full of unprintable characters which don't show with what you pasted into #5.

The semicolons in your first row are a consistent 9 columns apart. Did the blank columns happen on their own? If so, use replace or substitute to change those semicolons to chr(10) and give it a try.