Excel - Word Wrap Limit.

[B827]

Does anyone know if there is a limit to the number of characters in a cell which will wrap. I have been handed a spreadsheet which has cells with a large amount of text and wrapping enable. After about 1200 characters the wrapping stops on the last line of text. I can't find any reference to a limit.

Does anyone have some information?

Many thanks Sandy

 

[SkipVought]

Hi B,

Check Workbook and Worksheet specification in on-line help. Specifically, here's what it says about cells...

Length of cell contents (text) 32,767 characters. Only 1,024 display in a cell; all 32,767 display in the formula bar.

Wut U C is Wut U Get (wysiwyg) Skip,
metzgsk@voughtaircraft.com

 

[dianemarie]

Sandy, if you change your cell formats to General instead of Text, there is no limit, I believe. At least, it allows MUCH more space than Text. We also download wrapped text with many characters, and I haven't run out of space yet when using the General format.

 

[Dreamboat]

Text wrapping doesn't work right on merged cells. Also, why Excel? Move it to Word.

IMHO
LOL

http://www.TheWordExpert.com

 

[B827]

Thanks for those dianemarie and dreamboat, unfortunately it is not my data so I have to work with what I'm given. I'll try the general format and see what happens. Sandy