How do I copy a Word text file into Excel in a way that each char.

N

Newtech programmer

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

Dave Peterson

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
 
N

Newtech programmer

Thank you. Very helpful.

Dave Peterson said:
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
Click to expand...
 
Top