Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
HI,
Question about: Text import into EXCEL 2000. I am using the text import wizard of Excel to open a Wordpad document. I want every character to be put in a separate cell. The wordpad document is saved as a .txt document in Windows ANSI, (font: Courier), I am using the option "fixed width" (files are aligned in columns wit spaces) of the text import wizard. The user is asked to create line breaks. Every line break has to be entered individually. Is there a way to do this for the whole document at once, I mean automatically after every character, in one manipulation ? The only way the import wizard works in my hands is to give 256 mouse clicks, with the hazard of skipping one (or more). Does anyone have a suggestion ? -- Arend Haarlem, the Netherlands |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import comma delimited text | Excel Discussion (Misc queries) | |||
Can u Import Macintosh 2.1 Excel file into Windows Office 2000? | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
how to convert GETPIVOTDATA from excel 2000 to excel 2002... | Excel Worksheet Functions | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |