removing blank cells

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.

Select the range of cells on which you want to find and remove blank cells.

To select only the blank cells in this range use this menu:
Edit -> Go to -> special -> blanks

To delete the selected blank cells use this menu:
Edit -> Delete -> shift cells to the left

Hope this helps.

i will go try that right away.