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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Introduction to R

R is considered the predominant language for data scientist and statisticians. Learn how to use R for your own data science projects.

Rory ArchibaldCommented:
Format the cell as General, not as Text.
0
byundtMechanical EngineerCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
dbfromnewjerseyAuthor Commented:
OK. Thank you.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.