Replace empty cell with cell on right

  • Thread starter Thread starter Andy B
  • Start date Start date
A

Andy B

Hi all

I wish I could write macros!!
I have a spreadsheet of names and addresses (name, add1, add2, add3, add4,
add5). I want to mailmerge them but some add2s are empty, because whoever
typed the data in put the next line in add3, and some add3s are empty
because they used add4, and some add4s are empty etc etc This means that the
mailmerge (into Publisher - yuk!) puts blank lines into the address.
I would like (please!) a macro that, if I select the range add1-add5, will
squash the details to the left - so all of the empty cells are on the right!

Thanks.
 
Good news - you don't need a macro:

-Select the entire range of addresses, like A1:D100
-F5, Special, Blanks, OK
-Edit, Delete, Shift Cells Left, OK

--
Jim Rech
Excel MVP
| Hi all
|
| I wish I could write macros!!
| I have a spreadsheet of names and addresses (name, add1, add2, add3, add4,
| add5). I want to mailmerge them but some add2s are empty, because whoever
| typed the data in put the next line in add3, and some add3s are empty
| because they used add4, and some add4s are empty etc etc This means that
the
| mailmerge (into Publisher - yuk!) puts blank lines into the address.
| I would like (please!) a macro that, if I select the range add1-add5, will
| squash the details to the left - so all of the empty cells are on the
right!
|
| Thanks.
|
| --
| Andy.
|
|
|
 
Back
Top