View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Robert1998 Robert1998 is offline
external usenet poster
 
Posts: 2
Default IMPORTING PC-DOS PLAIN TEXT FILES WITH LEADING SPACES

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