Remove blank entries from a list. Useful for mail-merge.
File download: squashed_list.zip
This example is all formula driven - no VBA.
Select cell F2
Select a name ...
Column F shows the results picked from the address table (a range called AddressTable - not shown here, but is in the example file and ready for you to customise)
Column I shows the same information but has excluded the blank lines.
Here's the formula in F4.
Here's the formula in E4. It adds 1 to the value in the cell above, but only if there is some text in cell F4.
Here's the formula in cell I4.