Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 282
  • Last Modified:

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?
0
dbfromnewjersey
Asked:
dbfromnewjersey
3 Solutions
 
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
 
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rory ArchibaldCommented:
Format the cell as General, not as Text.
0
 
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
 
dbfromnewjerseyAuthor Commented:
OK. Thank you.
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now