| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Import a txt file with text fields that have meaningful leading sp
A little more clarification on the problem It is a fixed length text file -- let assum 10 chars per field, 2 fields 123456789|1234567890| Muehe ABC Muehe ABC I mark off the fields, i specify that both are text fields (not general) The second fields are not equal because of the leading spaces -- excel 2007 did not preserve the spaces. Doing the same process in excel 2003, worked. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I find meaningful file properties in Excel 2007? | Excel Discussion (Misc queries) | |||
| Add leading 0 to csv import text/time H:MM | Excel Discussion (Misc queries) | |||
| I'm trying to import fields from one Excel file to another | Excel Worksheet Functions | |||
| Overwriting error message #NUM! with meaningful text | Excel Discussion (Misc queries) | |||
| Import Pipe Delimited File, Parse out certian Fields, create new f | New Users to Excel | |||
Hybrid Mode
