Quote:
Originally Posted by Mazzaropi
Ricky, Good morning.
If now do you want to remove all spaces in both columns try this one:
C1 -- =VALUE(SUBSTITUTE(A1,CHAR(160),""))
D1 -- =SUBSTITUTE(B1,CHAR(160),"")
Please, tell us if it worked for you now.
|
im really sorry but its not working too, and i dont know why :(