IIRC, when I import a text file into Excel, I can set the column breaks manually, then quickly edit out the rows I don't want.
You might be able to make a script in UltraEdit or your favorite editor as well.
I'm sure there's a way to do it with scripting Excel, but the time it takes may be longer than doing it via the above.
HTH.
Cheers,
Scott.
You might be able to make a script in UltraEdit or your favorite editor as well.
I'm sure there's a way to do it with scripting Excel, but the time it takes may be longer than doing it via the above.
HTH.
Cheers,
Scott.