Thanks Dave,

The thing is the column 'description' (upper lower estimate) is a
cell. For example. I have these three columns:
Northern Europe, United Kingdom (Estimate); Northern Europe, United
Kingdom (Lower); Northern Europe, United Kingdom (Upper); in cells, say
A1, A2, A3. I want to delete A2 and A3 and all of the information below
them (the values for particular states).

Thanks