Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I increase the number of text characters in a cell
Hi there
I am working on an Excel spreadheet with lots of text. The cells seem to accept only a certain number of characters before the text runs out of the cell. Is there anything to increase the number of text characters in a cell? Any response would be highly appreciated Thanks J |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I increase the number of text characters in a cell
See this for a discussion of limits of XL 2003:
http://office.microsoft.com/en-us/ex...992911033.aspx (Since you didn't specify which version of XL you're using this may not apply to you. If that's the case, do a google search for your version of XL and its limits.) Dave -- Brevity is the soul of wit. "Preadno" wrote: Hi there I am working on an Excel spreadheet with lots of text. The cells seem to accept only a certain number of characters before the text runs out of the cell. Is there anything to increase the number of text characters in a cell? Any response would be highly appreciated Thanks J |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I increase the number of text characters in a cell
Excel Help on "limits" or "specifications" reveals that Excel will allow
32,767 characters to be entered in a cell. However, it goes on to state that "only 1024 characters will be visible or can be printed" To work around this limitation, stick a few ALT + ENTERs in at appropriate spots, about every 100 characters.. The ALT + ENTER forces a line-feed and expands the 1024 limit. How far is not really known. Just experiment. .........From Dave Peterson.......... I put this formula in A1: ="xxx"& REPT(REPT("asdf ",25)&CHAR(10),58)&"yyy" And adjusted the columnwidth, rowheight and font size and I got about 7300 characters to print ok. .........End Dave P................. Failing that, use a Text Box to store the text or MS Word which is a word processing application, unlike Excel which is not. Gord Dibben Excel MVP On Mon, 6 Nov 2006 06:03:02 -0800, Preadno wrote: Hi there I am working on an Excel spreadheet with lots of text. The cells seem to accept only a certain number of characters before the text runs out of the cell. Is there anything to increase the number of text characters in a cell? Any response would be highly appreciated Thanks J Gord Dibben MS Excel MVP |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
The number in this cell is formatted as text or preceded by an apostrophe" problem in Excel | Excel Discussion (Misc queries) | |||
Number of characters in a cell (one row, merged columns) | Excel Discussion (Misc queries) | |||
Max number if characters in a merged cell | Excel Discussion (Misc queries) | |||
Max number if characters in a merged cell | Excel Discussion (Misc queries) | |||
Count Number of Characters in a cell? | Excel Discussion (Misc queries) |