#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Max limit for text?

Is there a max limit for how much text can be input into one cell? I have a
large paragraph that I can see the whole thing in the fuction window, but I
can't stretch the box big enough to show all of the text. I just makes the
box bigger, but doesn't include all of the paragraph. Is there a work around
for this? Thank you.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1,316
Default Max limit for text?

There's maximum of 32,767 character per cell, with only the first 1,024
characters being displayed.

You can exceed the display limit somewhat by placing new line codes to
create line breaks by using <Alt+<Enter

--
Kevin Backmann


"lindsayhyle" wrote:

Is there a max limit for how much text can be input into one cell? I have a
large paragraph that I can see the whole thing in the fuction window, but I
can't stretch the box big enough to show all of the text. I just makes the
box bigger, but doesn't include all of the paragraph. Is there a work around
for this? Thank you.

  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 17
Default Max limit for text?

Thank you Kevin

"Kevin B" wrote:

There's maximum of 32,767 character per cell, with only the first 1,024
characters being displayed.

You can exceed the display limit somewhat by placing new line codes to
create line breaks by using <Alt+<Enter

--
Kevin Backmann


"lindsayhyle" wrote:

Is there a max limit for how much text can be input into one cell? I have a
large paragraph that I can see the whole thing in the fuction window, but I
can't stretch the box big enough to show all of the text. I just makes the
box bigger, but doesn't include all of the paragraph. Is there a work around
for this? Thank you.

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
Text box character limit Mickey Excel Discussion (Misc queries) 0 May 22nd 06 08:30 PM
text limit using a vlookup Dave D Excel Discussion (Misc queries) 1 March 14th 06 12:09 AM
text field limit tkaplan Excel Discussion (Misc queries) 4 November 9th 05 04:46 PM
Limit of text in cell. a94andwi Excel Discussion (Misc queries) 2 October 26th 05 04:30 PM
How do I limit what text is displayed? Erik Millerd Excel Worksheet Functions 4 July 15th 05 11:51 AM


All times are GMT +1. The time now is 07:56 AM.

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

About Us

"It's about Microsoft Excel"