How do I copy data (word) into respective cells when the data bei.

[Guest]

I have word data in 2 or more collums (not cells). When I copy and paste that
data into a cell (word or excel) all that data goes into one cell. How do I
get the data into the respective cells without going back and cut from one
cell to another?

 

[JulieD]

Hi

one method that i've used before to do this may work for you,
in Word, select the columns
then click on the INSERT TABLE icon on the toolbar - if you're lucky the
columns will convert to two tables side by side
then select the left hand side table (it might also select the right it
doesn't matter)
then click on the split cells icon (table split cells) (untick the merge
cells before split) and tell it to split into two columns (leave the row
value alone)
now your left hand side table should have two columns
select the values in the right hand side table and copy them
click in the first cell, 2nd column on the left and paste
now you should have your data in a table in two columns
then select the cells on the right hand side table and choose table / delete
/ cells - move cells left
some of your other table might now move to the right, if so, choose format /
columns and set it back to 1 and you should now have a two column table.

hope this helps
Cheers
JulieD