I'm trying to move text data from a cell(s) in one spreadsheet to a cell(s) in a different spreadsheet. I click the Copy icon in one sheet, move to the other sheet and click Paste. Frequently, not all the text data moves from the original sheet to the destination. This should be easy. What's going wrong?? Thanks.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Copy & Paste Help
- Thread starter BobbyM
- Start date
daniels012
Well-known Member
- Joined
- Jan 13, 2005
- Messages
- 5,219
More detail of when it does and does not work would help. Are you gettiing an error message? Are you selecting and copying multiple cells at once?
Need a bit more detail.
Michael
Need a bit more detail.
Michael
Upvote
0
It happens when the text data is large - 250 characters and up. No error message appears. The text just gets cut off. I've played with row height, column width, data validation in the receiving spreadsheet, but it doesn't help. It's like the bucket carrying the data can only hold so much. I've been trying to move single cells of data as well as 50 to 75 at a time. Thanks Michael.daniels012 said:More detail of when it does and does not work would help. Are you gettiing an error message? Are you selecting and copying multiple cells at once?
Need a bit more detail.
Michael
Upvote
0
daniels012
Well-known Member
- Joined
- Jan 13, 2005
- Messages
- 5,219
I understand now!!
I really am not sure about what you could do if your text exceeds the 250 character limit??
Michael
I really am not sure about what you could do if your text exceeds the 250 character limit??
Michael
Upvote
0
Similar threads
- Question
