Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Office 2K fully patched to latest updates.
We have several Excel spreadsheets with cells that have several hundred words in each cell. 1) When we highlight the cell and press COPY then go to another cell and press PASTE in another spreadsheet not all of the words are pasted. 2) When we highlight the cell and press COPY then go to word and press PASTE all of the words are pasted in a text cell. 2) When we highlight the cell and press COPY then go to notepad and press PASTE all of the words are pasted. There are multiple cells that need to be moved but we cannot use method 2 or three because there are thousands of cells like these. Is there anyway to change this default behavior? Thanx Fred |
#2
![]() |
|||
|
|||
![]()
I know this isn't the answer you want, but there is no reason for this
behavior. I can't duplicate it in EXCEL. You might want to look at the contents of the cell. Are there <CR's in the cell, or null characters? That might effect things. Dom "Fred" wrote in message ... Office 2K fully patched to latest updates. We have several Excel spreadsheets with cells that have several hundred words in each cell. 1) When we highlight the cell and press COPY then go to another cell and press PASTE in another spreadsheet not all of the words are pasted. 2) When we highlight the cell and press COPY then go to word and press PASTE all of the words are pasted in a text cell. 2) When we highlight the cell and press COPY then go to notepad and press PASTE all of the words are pasted. There are multiple cells that need to be moved but we cannot use method 2 or three because there are thousands of cells like these. Is there anyway to change this default behavior? Thanx Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How can I copy the formatted value and paste as a new value(not the original value with formatting)? | Excel Discussion (Misc queries) | |||
do cell refernces have to move when I cut and paste? | Excel Discussion (Misc queries) | |||
Copy and Paste | Excel Discussion (Misc queries) | |||
How do I copy page setup from one worksheet & paste into new shee. | Excel Discussion (Misc queries) | |||
Is there a way to transfer a style by cell referrence in a formula | Excel Discussion (Misc queries) |