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

Dear Pete,
Your are right, there are no line breaks. Introducing them by feeding every
letter a comma is a great idea. This means only 26 manipulations instead of
256.
Thanks a lot,
kind regards,
--
Arend
Haarlem


"Pete" schreef:

I thought you were saying that you didn't have any line breaks in the
file.

Well, following on from the Notepad/Wordpad idea, can't you use Find &
Replace in Notepad/Wordpad to change "A" to "A," and "B" to "B,", "C"
to "C," etc up to "Z" to "Z,". Then when you import it to Excel, you
can specify comma as the delimiter in the Text Import Wizard.

You need to be careful that there are no more than 256 characters on a
line, as this is the number of columns in Excel.

Hope this helps.

Pete