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 appreciated.

Cheers