Text Wrapping Problem

[Shashi Bhosale]

I have a text wrapping problem. Text Doesn't wrap after a certain point.
I have following text in a cell . Cell height is 380 and width 81.
mfdslfmsdlf sdflsdlfksdf sdfksdf'ksdf sdf'kdsf;kdsf dsf';kdsf;kdsf
dsf;kdjashd asjdhasdh asldkhslad saldhksadas asdlhsdlhas asdlhasldkhasd
asdlhasldhasd sadlkhsadkhasd asdlkhasdkhasd sadlkashdkasd asdkshadlhasd
asdlkhasdkhasd asdlkhsadkhsad sadlkshdkhsad asdkhasdhaslkd asdkshadlhasd
asdlkhsakdh sadlhsadlhas sadlasldkh sadlhsakdsh sdksakd asdlkhasdkhas
asdlkhsadkas asdlkhsdkhsd asdlksahdkhasd asdlkashdlkhsad asdlkhasdklhsad
asdlkhsdkhasd sldkhsalkdhasd asdlhaskdhasd sdashlkdhas asdlkhasdkhasd
asdlkhsakdhas skdhsakhd asdklhsadlkhas aslkdhaslkdh asdlkhasldhas asdkhasdh
sdlkhsadkhasld asdklhsadkhas ZZZZZZZZ asdlkhsakdh dslkashdkhasd
asdlkhsdlkhsad asdlkhasldkhas saldhaslkhdas asdlkhasdlhasd asdlkhaskdhas
asdkhsakhdalks asdlkhsaldkhasd asldhaslkdh sdlhasldkhas asdlkhasklhdas
sdlkhasdkhask asdklhasdkhasd sadlhaslkdhaskd asdlkhsadkhasd sdlkhaslkdhasl
daslkdhakshdkasld sadlkhasdhlkas dsakhaskdhlas sadkhasdhasd sadlhslakhd
saldkhaslkdhlask asdlkhslkdhasl asdlsalkdhas sadlkhaskdhasd asdkhaslkdhsa
sdlkhaslkd sadlkh

Text doesn't wrap after ZZZZZZZ . What's the solution for this problem?

 

[Tom Ogilvy]

go into your text at various location and do

Alt+Enter
to force a return. This should allow you to show more characters. There is
an upper limit on cell height, so you might want to make the font smaller as
well.

 

[Guest]

hi

i tried your text and row and column setting - i have no problem
wrapping the text.

i am using excel 2000 - what are you using?
what font size?



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Tom Ogilvy]

remove all the hard returns you get from copying it from the email, so it is
a text string with no hard returns in it. Put it in a cell, select it in
the formula bar using Ctrl+C, go to the end of the string and do Ctrl+V to
paste a copy - now the string is twice as long.

You should see that the entire string is not displayed in the worksheet (it
is in the formula bar).