WRAP adds blanks to cell with text

[Windy77]

I have a user who is adding text to cells within a spreadsheet. When these are full she used the Format / Cell Wrap option to allow the full text to be visible. Then she double clicked on the lower row nukber divider to re-siae teh height of the cell and in each case the row height changes to be about twice the height of the text, with a large space above the text (or below the text if teh cell allignment is changed to top).

I've checked Microsoft Knowledgebase sites & Tek_Tips & can only find links to similar problems where there are cells that have been merged, but as far as I can see (& user confirms) there are no merged cells in the spreadsheet.

If I copy the data or create a copy of the worksheet the problem goes away (i.e. the cell re-sizes height properly), unfortunately this isn't a viable solution since the length of much of the text is greater than 255, and anything longer than that is truncated in a copy operation.

It looks like some setting is wrong within this spreadsheet, but I can't see what - any thoughts would be appreciated.

 

[guava65]

That's a lot of text for a spreadsheet. Aside from your described problem, maybe youe end-user of using the wrong tool for the job. It sounds like the user may be able to use Word to create the document and have the spreadhseet functionality imbedded.

If you can't do that, you may want to have the user set the text-wrap function to the cell BEFORE typing all that text into it. It may be that in order to view the such a long string of text, the user is comensating by adding advance or trailing spaces. You won't see the problem becuase your copy and paste will only take limited characters then truncate the rest (which is probably where the trailing spaces are).

My first choice wuld be to use Word.

Good luck

Aloha,
cg

 

[Windy77]

Thanks for your response CG.

As for solving the problem, it remains a mystery. I've tried your suggestion & it works fine in a new spreadsheet with copied data, but unfortunately this looses much of the historic data due to truncation. Nothing I've tried so far has worked on the original "precious" file. I'm sure the user has changed something accidently, but until I find what the problem remains.

Btw, I agree it is the wrong application for the job, but has been used historically & the dept. manager isn't changing his ideas in a hurry. The spreadsheet contains lots of payment history data & is used to chase late payments, so the text is chase comments.

Cheers (in frustration)

Paul