Hi,

Thanks for the response. I am trying to retain formulas. The properties window doesn't mention anything about formulas. When I think of formatting, I think of font color, etc...

But what I would like is for the data to be TRIMmed, Concatenated, and have NULL entries replaced w/ NA.

Moreover, I am hoping to impose those formulas on import/refresh. This way I don't have to apply the same silly formulas day-in day-out.

Thanks,