Excel word wrap

  • Thread starter Thread starter cswagner
  • Start date Start date
C

cswagner

I have a problem wrapping text in excel when there are
alot of characters (greater than 200) in a cell with
several line breaks. Line breaks are entered using ALT -
ENTER. It seems the last line line or seveal lines of
text will not wrap. I tried AUTOFIT, manual adjusting
cell width, height, etc. The last lines of text just
disappear to the right of the cell. If you click on the
cell to edit the text, all text is there. It just does
not display properly in the cell. Does anyone know of a
fix? I think it may have to due with the number of
characters in the cell.
 
Hi cswagner!

Re: " think it may have to due with the number of characters in the
cell."

I think you're right.

32,767 characters. Only 1,024 display in a cell; all 32,767 display in
the formula bar

The max display in a cell does vary with the characters used.
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Back
Top