I don't understand the layout of your data.

You may want to post a typical example and what should happen to that example.

(Just plain text--please don't attach a workbook.)

mattrane wrote:

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

--

Dave Peterson