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?
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?
One way to acheive this would be to format your data in Microsoft Word into a table.
Draw a table of the correct number of columns, and rows, enter the data into that in Word. Then when coppied over in one large copy paste acrion, the data will be formatted in the same number of columns and rows as in Word.
Celtic_Avenger
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
"awg9tech" <[email protected]> wrote in message
news:[email protected]...
>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?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks