Might be easier to simply know what is in those cells and delete them
that way with Find/Replace. Many times downloaded data is repetitive.

What comes through from Access in those almost-blank cells?
A space? 2 spaces?
Non-breaking spaces?
Is it always the same?