Hi,

I have COLUMN B which goes from B2:B4000. Most cells have a text entry but a number of them are empty. I would like to put the entire list in COLUMN C less the blank entries. I want to use a formula, not a filter.

Appreciate any help.



Thanks


TB