Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Suzan Wild
 
Posts: n/a
Default How can I copy Word data into a merged cell in Excel?

I am trying to copy some text from a Word document into an Excel spreadsheet.
I get an error message about "data not same shape" then I get an error
message "cannot copy data into merged cell." I'm on Office 2002.
  #2   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

Unmerge the cell and paste it into the upper leftmost of the cells that were
merged, then merge again although I would strongly advice NOT using merged
cells, sooner or later (sooner) they are bound to cause problems, it is
pretty easy to get similar layout with center across selection etc

Regards,

Peo Sjoblom

"Suzan Wild" wrote:

I am trying to copy some text from a Word document into an Excel spreadsheet.
I get an error message about "data not same shape" then I get an error
message "cannot copy data into merged cell." I'm on Office 2002.

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
Copy one cell to entire column Tom Excel Discussion (Misc queries) 6 April 27th 05 11:39 PM
Can Excel Export Data to Word Format? Reddiance Excel Discussion (Misc queries) 2 April 18th 05 06:03 PM
How do i copy columns of data in notepad into microsoft excel? Jason Excel Discussion (Misc queries) 3 February 12th 05 02:04 AM
how do i set up excel to copy from one cell to a given number of . ronmjo Excel Discussion (Misc queries) 3 January 18th 05 08:49 PM
How can I display and print all the data in a wrapped merged cell. lflinders Excel Discussion (Misc queries) 1 January 6th 05 02:05 AM


All times are GMT +1. The time now is 12:46 PM.

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

About Us

"It's about Microsoft Excel"