ExcelBanter - Word wrap with 255 characters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Word wrap with 255 characters (https://www.excelbanter.com/excel-discussion-misc-queries/241288-word-wrap-255-characters.html)

GS Fanatic

Word wrap with 255 characters

Cells containing text with < 255 characters, wraps correctly. However, with
255 characters, a single line containing "######..." is displayed in the
cell. I'm using Office 2007 and have created big cells in order to contain
big notes.

Jacob Skaria

Word wrap with 255 characters

Try inserting line breaks inbetween...In edit mode F2. press Ctrl+ Enter

If this post helps click Yes
---------------
Jacob Skaria

"GS Fanatic" wrote:

Cells containing text with < 255 characters, wraps correctly. However, with
255 characters, a single line containing "######..." is displayed in the
cell. I'm using Office 2007 and have created big cells in order to contain
big notes.

Dave Peterson

Word wrap with 255 characters

Try formatting the cell as General (not text).

GS Fanatic wrote:

Cells containing text with < 255 characters, wraps correctly. However, with
255 characters, a single line containing "######..." is displayed in the
cell. I'm using Office 2007 and have created big cells in order to contain
big notes.

--

Dave Peterson

All times are GMT +1. The time now is 07:16 AM.