View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
georgex georgex is offline
external usenet poster
 
Posts: 1
Default How to make an Excel Cell contain text more than 31,737 Characters

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