Could not remove duplicates from the excel, duplicates removing from only one column but not from the other column
I am trying to remove duplicates from a dataset in excel which has 700k rows with 10 columns. I am trying to remove duplicates from the first row which has ID. Rest of the columns has data associated with this ID. when am trying to remove duplicates by using the Data Tools> Remove duplicates> on ID column it is deleting only the duplicates in ID column but not the other columns.
Finding the space
I performed this operation in excel =FIND(” “, A1) The result shows VALUE! Error.