Clear duplicate content in xl column

I am trying to clear duplicate content in the cells in column B of my xl table.   Remove Duplicates function is not suitable because it deletes rows.   I only need to clear the duplicate content ...