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
"Minnie" wrote:

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!

"stew" wrote:


In each cell is it the same amount of letters?

Stew
"Minnie" wrote:

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

"Bernard Liengme" wrote:

Are you sure? Have you looked in Formula Bar and/or made column wider?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

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