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

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

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

Thank you. Very helpful.

"Dave Peterson" wrote:

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