To remove the unwanted space characters in column C, type this formula in a spare column:
=TRIM(SUBSTITUTE(C1,CHAR(160),""))
Copy down to cover the corresponding entries in Col C.
Regarding the serial numbers, it isn't clear to me how to identify them. Can you explain a bit more?
Bookmarks