How to I copy and paste from WORD into EXCEL so that each word goes into an individual cell?

Question

Apologies if I have already asked this about 50 minutes ago. I can't see my old question so think I didn't upload it. Thanks for any help for my query. When I try to do it all the words go into one cell.

Answer 1

Copy and paste all the text into one cell then goto Data at the top menu bar...

You know from top left it says File Edit View Insert Format Tools the Data Depending on what version of excel you are on.



Click on Data



Then click on Text to columns

A wizard opens steps 1 to 3



Make sure dot is in Delimited then click next



Click the delimeters that apply in your case 'space'



Take the tick out of Tab which is usually ticked



Then click finish no need to go to step 3



Hope this helps?

Answer 2

Excel can put them in order but u would have to paste each word in its own cell. Once each word is in, on one of the menu bars you should see and down arrow with about 3 letter going down, push it and excel has put them in order, make sure you highlighted everything.

Answer 3

ok in word select the text and from the table menu select convert text to table and from the separator options change it to a blank space (i.e. not comma separated or dash) it should then put each word into a cell of a table - you might have to go back and change one or two settings to get it to behave properly.



Now when you copy and paste it each cell element will be in it's own excel cell

Answer 4

Right, PLEASE add more information in future to help people help you.



I'm going to wing it and suggest something:



You have your word document with unknown content (that bit is always helpful to know).



You could open Excel and go to "OPEN", at the bottom of the new window it refers to the format, select "All types" and locate your word document and click on 'open'.



You should see a new box asking how you want excel to deal with it. Click on the 'delimited' option.



Usually if you want to take information in a very basic form to a spreadsheet form, you have markers in the form of commas, colons and so on. You probably have nothing useful so you will see one option to use spaces - tick the box which refers to spaces.



See how that looks and good luck - but PLEASE provide more information in future, or make friends with a computer nerd :-)

Answer 5

Copy and paste everything so that it all goes into the one cell, then select that cell. Open up the data toolbar and select "text to columns" That will allows you to plit the text into individual cells