Okay, now that's just weird.

I tried it on column B first (delimited), so you'd think if there was anything EXTRA in the cell it would populate column C, but column C stayed just the way it was. Then I did column A, which should have wiped out B, but didn't. But sure enough, after that I could do my pastespecial routine.

Why would that happen, and how did you come up with that solution?