LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

I don't have a guess what could be happening?

If you put
=REPT("asdf ",250)
in A1 and then Edit|copy, Edit|paste special|Values

Can you add more text to that cell?



ChaimB wrote:

Basically, nothing happens! The cursor does NOT move at all, and there
is a "BEEP".

For "debugging" purposes I set a LEN function on this cell in another
empty cell and the size remains the same/

Thanks,

Chaim

Dave Peterson Wrote:
What happens when your customer tries to enter the 1023rd character?

Maybe he or she is just not seeing them.



ChaimB wrote:-

Is this true for EXCEL 2000?

I have a file from a customer which currently has 1022 characters in
one particular cell and I have NOT been able to enter any additional
characters - I did try issuing ALT-ENTER but this does not seem to do
anything.

I have noticed that in EXCEL 2003 I CAN enter many more characters!

For my own edification, what dose the 32 KB limit give me if
operationally I can enter only 1 KB+ number of characters?

Thanks,

Chaim

Gord Dibben Wrote:-
Ned

The maximum is 32,767 characters to a cell.

However, as Frank points out, only 1024 will show or can be printed.

Increase the 1024 by using ALT + ENTER at appropriate spots.

Gord Dibben Excel MVP

On Wed, 3 Nov 2004 00:49:04 -0800, "NED 1451" NED
wrote:
-
Can anyone give me some info on the maximum text size you can put in
a
cell.
How many characters/words

Thanx.

NED 1451--

--
ChaimB-

--

Dave Peterson


--
ChaimB


--

Dave Peterson


 
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
Cell set to wrap text and blank line -- fix? Fred Holmes Excel Discussion (Misc queries) 0 January 25th 05 07:10 PM
how to hyperlink text to a cell steve New Users to Excel 1 December 14th 04 08:21 PM
Macro or Function to make text size to suite text Length? lbbss Excel Discussion (Misc queries) 4 December 14th 04 07:53 PM
Formatting a cell as "text" in the number catagory. Ed Excel Worksheet Functions 3 December 7th 04 07:12 PM
GET.CELL Biff Excel Worksheet Functions 2 November 24th 04 07:16 PM


All times are GMT +1. The time now is 07:05 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"