View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Greg[_16_] Greg[_16_] is offline
external usenet poster
 
Posts: 10
Default Best options for importing text file

Can you please assist.

I have a text file that can incldue tabs, CR, and LF in the one field,
so I have delimeted the fields using a ^.

eg a field can be any combination of
^abcd....CR..abcd.TAB..abcd..CR..^

I wish to import the txt without the tabs, CR and LF. The file
contains about 24 columns, by about 200 rows.

What are my bext options?