String of numbers....

First, i would need to conver data to numbers as some of them are
formatted as =("#### "). And I assume that some may have leading/
trailing spaces since the data is uploaded.

Second, i need to keep any numbers that have been duplicated anywhere
in the string and DELETE the ones that appear only once.

String of data starts with C4 and the end of the list/string varies.