Text in cells

asudevils5150 · Feb 20th, 2002, 07:30 PM

I have Excel 97 and typed a 500 character text in a cell. On the edit line, all the characters show, yet on the display, only part of it is displayed. I did wrap text, column width adjustments and smaller fonts. Same thing when it prints in that only part of it is displayed. Please help.

RWinfield · Feb 20th, 2002, 07:33 PM

Excel has a 256 character limit per cell to the best of my knowledge.

Rick

asudevils5150 · Feb 20th, 2002, 10:49 PM

Can i merge two cells together with 1/2 on one cell and the other half of the text on the one below? Any suggestions? Thanks

anno · Feb 20th, 2002, 10:59 PM

with your 500 chars in A1 you could put =LEFT(A1,250) in one cell and =RIGHT(A1,250) or =MID(A1,251,250) in another below it. is that what you mean?
another thought is to use a text box

[ This Message was edited by: anno on 2002-02-20 22:02 ]

asudevils5150 · Feb 21st, 2002, 06:41 AM

I was thinking that if Excel 97 allows you to only display 256 characters per cell (i'm sure this is the case), then i would somehow need to break up my 500 character text into two cells. So cell a1 would have 250 characters (or around there) and cell A2 would have the remaining characters. Then on A3, i would somehow merge the cells together and display all 500 characters. I guess the question is, is there a way to get around the 256 character limit via display. When I go to the edit line on cell A1 where i have my 500 character text, I can see all the text on the edit line. Do i need to do some VBA work?

Juan Pablo González · Feb 21st, 2002, 06:54 AM

Nope. There's no "workaround", it's just a limitation (I think in Excel 2000 the limit is 1024, so that may be a workaround...)

Feb 21st, 2002, 06:54 AM	#6
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	Nope. There's no "workaround", it's just a limitation (I think in Excel 2000 the limit is 1024, so that may be a workaround...) __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 20th, 2002, 07:30 PM	#1
asudevils5150 New Member Join Date: Feb 2002 Posts: 49	I have Excel 97 and typed a 500 character text in a cell. On the edit line, all the characters show, yet on the display, only part of it is displayed. I did wrap text, column width adjustments and smaller fonts. Same thing when it prints in that only part of it is displayed. Please help.

Feb 20th, 2002, 07:33 PM	#2
RWinfield New Member Join Date: Feb 2002 Location: Washington State Posts: 33	Excel has a 256 character limit per cell to the best of my knowledge. Rick

Feb 20th, 2002, 10:49 PM	#3
asudevils5150 New Member Join Date: Feb 2002 Posts: 49	Can i merge two cells together with 1/2 on one cell and the other half of the text on the one below? Any suggestions? Thanks

Feb 20th, 2002, 10:59 PM	#4
anno Board Regular Join Date: Feb 2002 Posts: 202	with your 500 chars in A1 you could put =LEFT(A1,250) in one cell and =RIGHT(A1,250) or =MID(A1,251,250) in another below it. is that what you mean? another thought is to use a text box [ This Message was edited by: anno on 2002-02-20 22:02 ]

Feb 21st, 2002, 06:41 AM	#5
asudevils5150 New Member Join Date: Feb 2002 Posts: 49	I was thinking that if Excel 97 allows you to only display 256 characters per cell (i'm sure this is the case), then i would somehow need to break up my 500 character text into two cells. So cell a1 would have 250 characters (or around there) and cell A2 would have the remaining characters. Then on A3, i would somehow merge the cells together and display all 500 characters. I guess the question is, is there a way to get around the 256 character limit via display. When I go to the edit line on cell A1 where i have my 500 character text, I can see all the text on the edit line. Do i need to do some VBA work?