G
georgex
I've read the following KB article:
XL2000: Data Overwritten Copying More Than 31,737 Characters
http://support.microsoft.com/kb/211965/en-us
Yes, an Excel cell definitely can contain text more than 31,737 characters.
The point is how to copy the data into it from somewhere else, for example,
NOTEPAD?
I have tried:
1. Change the cell format from "General" to "TEXT".
2. Active "Edit Mode" (F2), then copy the long string piece by piece. This
does not work, it will not allow you copy the last several pieces if the
current cell is over 31,737 characters.
3. Make an CSV file with the long string, import it into Excel. Also does
not work.
Can anyone tell me a way to do this except for typing the long string
manually? I know this might be the last way I can try and it certainly works.
Thanks,
George
XL2000: Data Overwritten Copying More Than 31,737 Characters
http://support.microsoft.com/kb/211965/en-us
Yes, an Excel cell definitely can contain text more than 31,737 characters.
The point is how to copy the data into it from somewhere else, for example,
NOTEPAD?
I have tried:
1. Change the cell format from "General" to "TEXT".
2. Active "Edit Mode" (F2), then copy the long string piece by piece. This
does not work, it will not allow you copy the last several pieces if the
current cell is over 31,737 characters.
3. Make an CSV file with the long string, import it into Excel. Also does
not work.
Can anyone tell me a way to do this except for typing the long string
manually? I know this might be the last way I can try and it certainly works.
Thanks,
George