"Different/special" leading/trailing spaces

[Eamonn100]

I have leading and trailing spaces either side of values. I'm getting rid of said trailing/leading spaces with =TRIM(CLEAN(A1)).

The problem is some of the spaces are "different/special" spaces, (I don't know what type, just that they are different). When I use this =CODE(LEFT(A1,1)) I don't get 32. So my =TRIM(CLEAN(A1)) formula isn't working for the ones that are different type of spaces.

Can anyone help with a formula that trims the leading/trailing spaces when they are "different/special" spaces.

 

[Norie]

What do you get when you use =CODE(LEFT(A1,1))?

 

[Eamonn100]

I get 160.