I'm using a macro to import a series of fixed-width text files. The problem I'm having is that for some lines of data the name field will drop all the spaces in the name and screw up those lines of data. For example something like this:
John Moe Doe 1003 10000
Will get imported as...