Forum Discussion
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 ...
Select column B only and then click Remove Duplicates on the Data tab of the ribbon.
Excel may display a warning:
Select 'Continue with the current selection', then click Remove Duplicates...
Excel will leave the other columns alone.