I have created a formula in excel that generates a range of cells. Within
that range there are some blank cells.

I wish to create a formula that looks in this range of cells and selects
only the cells with values in them, ignoring the blanks. It returns these
values in a new range with no blanks.

Can someone help?

Thanks

Nick