i combined several data bases that were unfortunately not formatted the same so now they look like this:

(last name)(first name)(address)(blank)(city)(state)(zip)
(last name)(blank)(first name)(address)(blank)(city)(state)(zip)

how can i make excel find the blank cells, remove them, then move the next cell to the right over left, so that all the data lines up the way it should?

thank you.