If your imported text looks odd, Excel has clean-up formulas that fix it in seconds:
=TRIM(A1) removes extra spaces.
=PROPER(A1) capitalises the first letter of each word.
=CLEAN(A1) deletes hidden or non-printable characters.
Use them in a new column, then copy and paste the cleaned results as values.
👉If you want to update the original data, copy the formula result and use "Paste Special" > "Values" to paste over the top of the original.