Hi,

I am using MS-Query to pull some data from our database. Depending on the
criteria I'm using there may be more or less rows selected. To the right of
the data that's fed into the spread sheet I have a column that calculated
based on two of the fields brought in from the database.

When there are more rows than the previous set of data the calculated column
doesn't automatically expand the calculation for the new rows. I have to
manually copy and paste the calculation. If there are less rows then I get
an error because there is no data to make the calculation from.

I also have to trim spaces from a couple of the fields brought in by the
database. Since this data is being used by non-technical people and it's
quite time consuming to do it over and over I'm wondering if there is a way
to have Excel do these operations automatically. If so then what's the best
way?