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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

problem importing text into excel 2007 2
Copying a table from Word 5
Importing a Text File Into 1 Column 3
HOW DO I CONVERT A .TXT FILE TO EXCEL 2
Excel Convert word into numbers and back 4
Copy text from word with returns into one cell 8
How to type each letter of the alphabet automatically in a specific color in Word? 0
Plain text to fill a single column: how? 2

Back
Top