HAHAHHAAH. That's the whole point of this vba exercise. I'm copying in the data from a PDF (it's a couple of hundred rows long). That's the cleanest I can get it. The vba is supposed to clean it up by combining the text columns and then pullling the numbers to the left.