View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
JoeA2006 JoeA2006 is offline
external usenet poster
 
Posts: 7
Default Tab delimited ? text import

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?