Cutt-Off In Cells text

[BryanHec]

I have a very complicated Worksheet in which many of the cells contains over 1000 characters. In Excel we have a limitation on the amount of text that you can print or view. We had manually added Line Feeds and then resize every row to be able to work with the content. Do exist a programming solution to this problem (or any solution other than having to do this manually)

Thank you

 

[SkipVought]

Hi,

If you have not MERGED cells, you can use the AutoFit feature.

Hit the Select All button.

Double-click on any row/column boundary

Skip,
[sub]
[red][/red]
[/sub]

 

[BryanHec]

Thank you but that technique do not work if you exceed the limit for the text on a single cell.

 

[xlhelp]

Add a macro that inserts CHAR(10) after so many characters or after a punctuation mark. Post in VBA forum if you don't know how.

Me transmitte sursum, Caledoni!