Excel 2007: Word wrapping in merged cells

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jgcrews - 30 May 2008 18:01 GMT

I have several text cells merged into a larger single cell. I have word wrap
& merge cells checked under formatting. One some of the cells, the text
entered displays as I expect it to. However, on other merged cells, the text
doesn't display - just a series of pound signs. Anyone have a suggestion as
to what is causing this and how I go about resolving it?

Reply to this Message

Jim Rech - 30 May 2008 18:14 GMT

If you enter text longer than 255 characters in a Text formatted cell you
get ######. All versions of Excel and it doesn't matter if the cell is
merged. Best to go with General format or at least not Text if possible.

Signature

Jim

|I have several text cells merged into a larger single cell. I have word wrap
| & merge cells checked under formatting. One some of the cells, the text
| entered displays as I expect it to. However, on other merged cells, the text
| doesn't display - just a series of pound signs. Anyone have a suggestion as
| to what is causing this and how I go about resolving it?

Reply to this Message

jgcrews - 30 May 2008 18:54 GMT

Thanks Jim for the quick response. I changed the format to "General" and it
solved the problem. The Excel documentation stated that the maximum number
of characters per cell is 32,767 so I thought that would apply. Since it was
purely text being entered (notes from telephone calls), I assumed that "Text"
was the proper format to use. I learn something new (& screwy) every day.

Jeff

> If you enter text longer than 255 characters in a Text formatted cell you
> get ######. All versions of Excel and it doesn't matter if the cell is
[quoted text clipped - 8 lines]
> as
> | to what is causing this and how I go about resolving it?

Reply to this Message