The standard TRIM function in EXCEL only removes soft spaces (ASCII 32) but not non-breaking spaces (ASCII 160) which is often the case from pastes from the web.
=TRIM(SUBSTITUTE(C2, CHAR(160), CHAR(32)))
NOTE: Also check for embedded tabs that might be utilizing the same formula but replacing ASCII code 160 with 9.