Clean Up Messy Text Fast

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.