You cannot change how Excel behaves but you can turn off word wrap after the
query. A macro can make this quick and easy.

Also, is there anyway to prevent excel from spilling long text into the
next column if the next column is blank?

Yes, leave on word wrap<g. Oh you want to eat your cake and have it too?
Well I'd leave word wrap on and then change the row height manually (or by
macro) to one line's height.

--
Jim
"Mark Olsen" wrote in message
...
| Hi, I am using VBA to query a database and then putting data into cells.
| Some values have really long text in them and excel automatically turning
on
| wordwrap for some of them which results is very large cells in some places
| which throws off the view of the worksheet. Is there any way to prevent
| excel from doing this. i dont mind not being able to see all of the text.
| Also, is there anyway to prevent excel from spilling long text into the
next
| column if the next column is blank? Thanks
|
| Mark