32 is a space isn't it, probably not a good idea to remove that.
Also, in case you don't know, you can embed the subs
=SUBSTITUTE(SUBSTITUTE(A1,CHAR(10),""),CHAR(13),"")
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
salvo00 said:
I found out that there are several characters codes: 10, 13, 32
Doing =SUBSTITUTE with all characters (i have found) solves the problem.
I am not sure yet but I am testing it ..
Thanks very much for all your help.