Program cell to delete other cell values
 

I'm trying to setup a spreadsheet so that when I enter a
value in this case a text value that excel will search the
other cells and delete the value from the cell it finds it
in.