Bob,

Thanks, but I think you misunderstand. I am not trying to delete
blanks within cells, but rather to delete blank cells entirely and
shift cells to the left.

JG Scott