Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 12th 05, 04:45 AM
awg9tech
 
Posts: n/a
Default How do I copy data (word) into respective cells when the data bei.

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?

  #2   Report Post  
Old January 12th 05, 11:26 AM
JulieD
 
Posts: n/a
Default

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" wrote in message
...
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
To safety merge cells without data destroyed, and smart unmerge! Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:17 AM
Heps to design Locked/Unlocked cells in protected worksheet Kevin Excel Discussion (Misc queries) 0 December 30th 04 07:09 AM
Convert data of cells to any type: Number, Date&Time, Text Kevin Excel Discussion (Misc queries) 0 December 30th 04 06:55 AM
Vlookup of parts of a word in a range of Data Andre Croteau Excel Discussion (Misc queries) 3 December 19th 04 07:26 PM
Word field codes in Excel data file Includetext mranz Excel Discussion (Misc queries) 1 December 7th 04 11:19 PM


All times are GMT +1. The time now is 05:55 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017