View Single Post
  #2   Report Post  
Dave Peterson
 
Posts: n/a
Default

Paste each line into column A.
Then put this in B1:
=MID($A1,COLUMN()-1,1)
drag to the right (as far as you need--but you've only got 256 total columns)
and drag down the range



Newtech programmer wrote:

How do I copy a Word text file into Excel in a way that each character ends
up in a separate Excel cell?


--

Dave Peterson