wrapping problem

[Patricia Dower]

I exported an Access query report to Excel.

I am able to format the Excel version of the report except for I am unable to wrap. I've got one column that has "Company Name" and "Policy #", and I can not "see" the policy number (unless of course I make the cell very long).

I've never had a problem with wrapping in Excel before. I've checked all the obvious. I've also imported Access query reports before, and never had this problem.

Any ideas out there?

Many thanks . . .

 

[plettieri]

Hi:

Are there spaces between the words you are trying to wrap?

plettieri

 

[Patricia Dower]

Hi . . . yes, there are spaces between the "Insurance Company Name" and the "Policy #". I use Excel sheets with such spaces within cells all the time, and do not have trouble wrapping.

It seems more like a wrap problem because I generated the report in Access.

Didn't mention before that I tried to wrap a few of the column headings, and that didn't work either.

As a "go by way of China" quick fix, I reformated the cells in question - made them wider, eliminated some of the spacing. Now I can "see" Insurance Co and Policy # on my report, so my problem is not as urgent as it was.

Thank you for your reply. Any suggestions will be appreciated.