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

Pete,
Thanks for your speedy response.
I tried your suggestion but that won't work. Here an example of what I want:
Every single character in the next lines needs to go into a new cell:
MAVMAPRTLLLLLSGALAL
MAVKAQRTLLLLLSGTLAL
MVVKAPTTLLZLLSKATAK

And those characters need also to be lined up vertically. The result is like
putting a grid over this block.
In reality the lines are much longer (up to 256 characters, hence the use of
wordpad or notepad instead of WORD) and there are hundreds of lines.
Hope this sparks another suggestion.
--
Arend
Haarlem


"Pete" schreef:

Are you saying that there aren't any line breaks in the file? Perhaps
you can load the file into Wordpad or Word and use Find & Replace to
insert line breaks at the appropriate place and then import the file
again.

Hope this helps.

Pete