| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Tab delimited ? text import
Is there a way to import a text file with variable length fields into excel
as fixed length fields. Two lines from the text file might look like this ABCDE DESCRIPTION 1 54.00 03/03/06 123456 ABC DESCRIPTION 2 23.00 03/03/06 123 I am not sure what the delimiters are because there are spaces within fields. I believe it must be tab delimited. Would I have to use VBA to accomplish this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Text import wizard defaults? | Excel Discussion (Misc queries) | |||
| text import into excel 2000 | Excel Discussion (Misc queries) | |||
| Excel Text Import Wizard | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| how do I enable "import text file" excel 2002? | Excel Discussion (Misc queries) | |||
Linear Mode
