Is there a way to import a text file with variable length fields into excel
as fixed length fields. Two lines from the text file might look like this

ABCDE DESCRIPTION 1 54.00 03/03/06 123456
ABC DESCRIPTION 2 23.00 03/03/06 123

I am not sure what the delimiters are because there are spaces within
fields. I believe it must be tab delimited. Would I have to use VBA to
accomplish this?