Selecting Values from a cell seperated by semicolon

[Snowbull]

Hi,

I am using Excel 2007 in windows 7 I would like to delete values within a cell which are separated by semicolon. Eg

A1 B1 ; C1 ; D1 ; B2 ; C2 ; D2 D1 A2 B2; C3; D1; B4; C4; D2 D2 A3 B5; C5; D1; B6; C6; D2 <colgroup><col style="width:48pt" width="64"> <col style="mso-width-source:userset;mso-width-alt:3181;width:65pt" width="87"> <col style="width:48pt" width="64"> </colgroup><tbody> </tbody>

<colgroup><col><col></colgroup><tbody>
</tbody>

In the above example D1 and D2 are in the third colomn which means D1 and D2 should be deleted from the second column and all other values should remain. In the real senario I have 208 rows in colum1 a minimum of 20 values in each cell in column 2 and 101 rows in column 3.

Please advise a solution for this.