| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copying and Pasting
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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! |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Minnie" wrote: 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! |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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 "Luke M" wrote: 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. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Minnie" wrote: 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! |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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! |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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! |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
We cannot just leave you unaided.
Can you send me a file with sample data To me not newsgroup - just remove TRUENORTH. 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! |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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! |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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 "Bernard Liengme" wrote: We cannot just leave you unaided. Can you send me a file with sample data To me not newsgroup - just remove TRUENORTH. 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! |
|
#10
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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! |
|
#11
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Copying and Pasting
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 "Minnie" wrote: 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 "Bernard Liengme" wrote: We cannot just leave you unaided. Can you send me a file with sample data To me not newsgroup - just remove TRUENORTH. 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copying and Pasting | Excel Discussion (Misc queries) | |||
| Copying and pasting | Excel Discussion (Misc queries) | |||
| Copying and Pasting | Excel Discussion (Misc queries) | |||
| Copying and pasting ??? | Excel Discussion (Misc queries) | |||
| Copying and Pasting | Excel Discussion (Misc queries) | |||
Linear Mode
