Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I get entries over 1000 characters to display in a cell?
I'm converting a paper form to an excel version. I need one cell for the
user to enter a narrative. I want the printed copy to show the full entry. I think 2000 to 2500 characters is probably long enough for most users. The problem I'm running into is text that stops wrapping after about a 1000 characters. Thanks for any help. |
#2
|
|||
|
|||
Whilst there is the method of inserting ctrl/enter characters to reflect more text you will find the odd user who will demand that 'more' characters are displayed. This, of course, also applies to printing. One method is to insert 31 following rows as helper rows, and a formula of =mid(A1,1024,1024) =mid(A1,2048,1024) =mid(A1,3072,1024) etc etc This will display the full 32,768 characters permitted in a cell, and will print the same. It is messy, and I would recommend the use of a Word processor for volume text processing. Mike in Berkeley Wrote: I'm converting a paper form to an excel version. I need one cell for the user to enter a narrative. I want the printed copy to show the full entry. I think 2000 to 2500 characters is probably long enough for most users. The problem I'm running into is text that stops wrapping after about a 1000 characters. Thanks for any help. -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=466576 |
#3
|
|||
|
|||
Hi Mike
The Excel limitation or characters in a cell is 32767, but there is a display limitation of 1000 characters. You can overcome this if you have line breaks in your text. Whilst typing, enter Alt+Enter after a number of sentences to force a new line. You can insert the character for line feed CHAR(10) with a formula if required e.g. in an adjacent column you could enter =LEFT(A1,900)&CHAR(10)&MID(A1,901,900)&CHAR(10)&MI D(A1,1801,900) -- Regards Roger Govier Mike in Berkeley wrote: I'm converting a paper form to an excel version. I need one cell for the user to enter a narrative. I want the printed copy to show the full entry. I think 2000 to 2500 characters is probably long enough for most users. The problem I'm running into is text that stops wrapping after about a 1000 characters. Thanks for any help. |
#4
|
|||
|
|||
You might want to consider putting the text in a TextBox control
rather than directly on the worksheet. "Mike in Berkeley" <Mike in wrote in message ... I'm converting a paper form to an excel version. I need one cell for the user to enter a narrative. I want the printed copy to show the full entry. I think 2000 to 2500 characters is probably long enough for most users. The problem I'm running into is text that stops wrapping after about a 1000 characters. Thanks for any help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
How do I change multi-line entries to single line entries in Exce. | Excel Worksheet Functions | |||
how do i see more than first 1000 unique entries filters dropdow.. | Setting up and Configuration of Excel | |||
Function Help | Excel Worksheet Functions | |||
Amortization Schedule | Excel Worksheet Functions |