Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I make all my text appear in my cell in Excel? | Excel Discussion (Misc queries) | |||
How can I make an excel cell equal to the value of a frame object text box | Excel Worksheet Functions | |||
How can I make an excel cell equal to the value of a text box | Excel Worksheet Functions | |||
How do you make some characters in a cell bold and some not? | Excel Discussion (Misc queries) | |||
How can I make Excel Files save as the text appers in a cell, can. | Excel Discussion (Misc queries) |