excel is bad - trailing characters is worse

I had to copy some text from a table in IE to Excel and then use a concatenate() formula.

But the result contained always a trailing space or so it seamed.

But =trim() or =clean() did not remove it.

Thanks to the online help, I found the following which solved my problem:

=TRIM(SUBSTITUTE(A4,CHAR(160),CHAR(32)))