DataFormat.Error: Invalid cell value '#NAME?'.

Hi,   I get this error when trying to identify duplicates from a column called "Full Name". There is no value there with  '#NAME?' so I cannot seem to remove it too. Any suggestions are greatly app...