Copying and Pasting

M

Minnie

I'm trying to copy cells of text from one workbook to another. I select the
cells containing the text, copy and then go to my new workbook and paste.
All ok except that it only pastes about half of the text from each cell into
the new workbook. Very frustrating! Please help!
 
B

Bernard Liengme

Are you sure? Have you looked in Formula Bar and/or made column wider?
best wishes
 
L

Luke M

Is it truly only pasting half the text, or is it only displaying half the text?
You might need to change the column sizes of your new workbook to allow all
the text to be displayed.
 
M

Minnie

Yes, it is only pasting half the text! I've resized columns, rows etc but the
rest of the text isn't there! It's as if the new workbook has limited the
number of characters that can be entered into each cell.
Thanks for your help, anyway.
Minnie
 
M

Minnie

Yep, changed column, row size etc but still not all the text. It's even cut
it off mid-word!!
 
B

Bernard Liengme

We cannot just leave you unaided.
Can you send me a file with sample data
To me not newsgroup - just remove TRUENORTH.
best wishes
 
M

Minnie

Yes, I think it is. Roughly 250 characters. It's as if there is a limit on
the number of characters in the cells in the new workbook. Is this a feature,
and if so, can it be turned off!
 
M

Minnie

Many thanks for this suggestion. I do appreciate it, but it would be more
than my job's worth! It's all confidential school reporting data.
I think I may have found a way around it. I 'paste special' and then select
'text'. It's a bit of a faff cos I have to restore the formatting, but at
least it's doing it!
Let me know if you come up with any other ideas!
Cheers,
Minnie
 
S

stew

Dear Minnie

You are correct. It happens with me as well , which would indicate that
there is some kind of clipboard restriction. You can get round it by going
back to the original text and copy the missing text only and add it on to the
first copied piece. Not an ideal solution but "if push comes to shove". I
will watch with great interest.

Best

Stew
 
S

stew

Dear Minnie
If you Copy the contents of a cell to a word Document it copies fine and in
total.
If you the copy the word doc Copy to the new cell it copies fine

Very Strange

Stew
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top