import many text files

  • Thread starter Thread starter Serge
  • Start date Start date
S

Serge

I have to import text files in Excel. I'd like to bypass
the procedure of "lines to skip" and "Delimiter
Selection" since it's always the same.

Is there a way to tell Excel how to import a certain type
of file (regarding the extention) and to do it without
asking questions ?

Thank you
 
If your text files are comma delimitered, then changing
the file extension to .csv rather that .txt will cause
Excel to open your text file without going through the
import wizard.
 
Back
Top