Invisible characters are a great threat to accurate results when working with texts.
Trim functions work well to remove Char(32) [spaces] but not Char(160) [non-break space] characters.
The solution to cleaning non-break spaces is using the SUBSTITUTE function.
=SUBSTITUTE(text,CHAR(160),"")
If you have both spaces and non-break spaces, you must combine the TRIM and SUBSTITUTE functions.
=TRIM( SUBSTITUTE( text, CHAR(160),"") )See the below video for more explanation.
Recent Comments