TRIM and CLEAN

Remove unwanted spaces and non-printing characters from imported data.

Practical example

=TRIM(CLEAN(A2))

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.