Text wrapping problem in Excel

I have 5 merged cells in an Excel worksheet.  Formatted as Text, Merged Cells, Wrap Text.  I only have a couple of hundred characters typed into the merged cells (I didn't count the characters but it's only about 3 sentences worth.)  If I type anything beyond that, the characters all change to pound signs. I tried manually adjusting the row height and that doesn't correct the problem. Anyone ever encounter this before?  Any fix?
dbfromnewjerseyAsked:
Who is Participating?
 
byundtCommented:
In Excel 2003, you get the pound signs with 256 characters when you format as Text. You can display 1024 plus a variable number additional if you format as General, as rorya suggested. The cell may contain up to 32,767 characters.
0
 
Raymond PengSystems EngineerCommented:
you need to select shrink to fit first.  Deselect all, select shrink to fit, then select the other options as well.
0
 
csoussanCommented:
You can only display 1,024 characters in a cell in Excel.  How may do you have?
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
dbfromnewjerseyAuthor Commented:
Shrink to fit does not work either. Had already tried that. Like I said, there are only a couple of hundred characters.  Just a little longer than what I just typed.
0
 
Rory ArchibaldCommented:
Format the cell as General, not as Text.
0
 
dbfromnewjerseyAuthor Commented:
OK. Thank you.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.