Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi
How can I (without the use of VBA) copy a large sheet where several cells have more than 255 characters, without truncating the characters to a max of 255? Thanks Excel 2002 SP3 (This cannot be changed) |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Copy the sheet and allow the truncation.
Then go back and copy all the cells and then paste over the new sheet. (Same thing in vba, too!) Gary Grung wrote: Hi How can I (without the use of VBA) copy a large sheet where several cells have more than 255 characters, without truncating the characters to a max of 255? Thanks Excel 2002 SP3 (This cannot be changed) -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy all but last 9 characters of a cell | Excel Discussion (Misc queries) | |||
How do I copy more than 255 characters per cell? | Excel Discussion (Misc queries) | |||
How can I copy characters from a cell that follow a hypen | Excel Discussion (Misc queries) | |||
How to copy the cell contains above 255 characters from one sheet. | Excel Discussion (Misc queries) | |||
enter formula to copy characters in a cell less last one | Excel Discussion (Misc queries) |