Replace empty cell with cell on right

[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.

 

[Jim Rech]

Good news - you don't need a macro:

-Select the entire range of addresses, like A1100
-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.
|
|
|

 

[Andy B]

Jim

Thanks a lot. Why didn't I think of that!