Excellent stuff guys, both subroutines did exactly what I needed. Jake,
it doesn't matter whether the formatting steps happen before or after
the file is imported, but as you said it is much easier if the file is
opened in excel first. I also had to find a subroutine that would go
through and delete blank rows.

Thanks much again,

Roman