I have a text file that is in tab delimited columns, except that certain rows
of the text file don't fit the columns. Like this:

ID #/Name Days Dollars
1234567 10 $200
Abrahamowitz, Alexander

7892346 5 $100
Smith, Bob

As you can see, the second individual's information fits into some standard
column breaks, but not the first. When I import the text into Excel, I
cannot automatically break the information into even columns because of this
problem. This is a very long list and making the changes individually
defeats the purpose of importing this into Excel. Is there any easy way to
reformat the original .txt file before importing it, or reformatting after it
is imported?

Thank you for your help.

-Patti