When importing text field Excel chops off leading spaces

  • Thread starter Thread starter septimus
  • Start date Start date
S

septimus

I need to import text files into Excel. These files have a field that
contains a long series of letters, representing student responses to
test questions. When I import these as Fixed Width data, putting in
the break points manually, Excel chops all leading spaces off of those
long series of letters. In other words, " BCD DA" becomes "BCD DA".

Obviously, this makes it appear that the student answered the first
two questions "BC" when really she failed to answer those first two
questions.

This happens regardless of whether I designate that column as a
General or Text field.

When I import the text file into Access, I don't have this problem. Is
there any way to fix it in Excel?

Thanks.
 
Hm. That does seem to work. Maybe not the most elegant solution in the
world, but it does appear to get the job done. Thanks!
 
Back
Top