| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel File in Use Notification Missing?? | Excel Discussion (Misc queries) | |||
| Export excel file to semicolon delimited text file | Excel Discussion (Misc queries) | |||
| Excel to Excel, Cut & Paste, 1 cell, text, multiplies file size f. | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
| Locating a file in excel with a partial file name. | Excel Discussion (Misc queries) | |||
Linear Mode
