Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I make all my text appear in my cell in Excel? Angela Excel Discussion (Misc queries) 1 June 16th 06 02:00 PM
How can I make an excel cell equal to the value of a frame object text box directionalman Excel Worksheet Functions 1 February 27th 06 09:24 PM
How can I make an excel cell equal to the value of a text box [email protected] Excel Worksheet Functions 5 February 27th 06 03:12 AM
How do you make some characters in a cell bold and some not? tracman Excel Discussion (Misc queries) 4 March 28th 05 05:17 AM
How can I make Excel Files save as the text appers in a cell, can. I khan Excel Discussion (Misc queries) 1 February 1st 05 07:34 PM


All times are GMT +1. The time now is 03:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"