View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Muehe Muehe is offline
external usenet poster
 
Posts: 2
Default Import a txt file with text fields that have meaningful leading sp

I am using the import text file in excel 2007 and it is acting different than
it did in excel 2003
i have a text field that can have leading spaces --the spaces are menaingfull.
In 2003, setting the field to text on the import preseved the leading spaces
-- not so with 2007. It left justifies the field.
Just wondering if there is an option that i can set? Or some different
method of doing it.