LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I find meaningful file properties in Excel 2007? Collegeprof Excel Discussion (Misc queries) 2 January 5th 12 09:37 PM
Add leading 0 to csv import text/time H:MM Mic Excel Discussion (Misc queries) 6 June 13th 07 01:51 AM
I'm trying to import fields from one Excel file to another Angel Incognito Excel Worksheet Functions 1 November 2nd 06 10:09 PM
Overwriting error message #NUM! with meaningful text Radio Ham Excel Discussion (Misc queries) 3 September 2nd 05 05:33 PM
Import Pipe Delimited File, Parse out certian Fields, create new f StarBoy2000 New Users to Excel 4 July 17th 05 07:36 AM


All times are GMT +1. The time now is 01:10 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"