wordwarp in excel after export

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

When I export my query into excel all the formatting in excel in all the
cells text have word wrap format on them. If the column width is shorter then
the text it does not appear correctly - only the last part is showing.

What I want to know - is there someway of forcing the formatting on the text
fields, such as no word wrap, or left justified?

I am using a command button and macro on a form to export the query.

Thanks

Susan
 
Hey Jason,

No carriage returns in any of the data.

Example data (I've transposed it to make it readable in this post:

Barcode: 1
User Code: TV 0203 field work & TV cleanup 0304 site
Notes: Field notebook for Thala Valley site assessment 2002-03 & TV tip
cleanup site assessment/verification 2003-04.
Custodian: 4687
Container Type: -1
Container Weight: 0

Cheers

Susan
 
Back
Top