Hi,

why don't you record the import process. Choose Tools, Macro, Record new
macro, save it in this workbook, don't worry about anything else and click OK.

Now the steps you should record - Choose File, Open, change the files of
type to *.Txt or All Files and navigate to the drive and folder, pick the
file and click open. The Import Wizard should appear. Follow the steps and
when the file is in, turn off the recorder.

--
Thanks,
Shane Devenshire


"Robert1998" wrote:

Hello,
I am having trouble importing plain MS-DOS text files. Leading spaces on
lines get removed in Excel . How can I prevent the removal of the leading
spaces?

Example ... ORIGINAL TEXT LINE = "_____Thank you"
IMPORTED in excel = "Thank you"
The import wizard shows the leading spaces correctly.
Font used is COURRIER NEW (monospace I believe)
Cell format is TEXT.

Thank you