View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Arend
 
Posts: n/a
Default text import into excel 2000

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