Quote:
Originally Posted by Ricky Martin
many don't work, i dont know what happen but now i have 2 problem and i upload it www.mediafire.com/view/?ecc71y94v1zihdw
hope it work, honestly im tired of this, but i must finish this
i dont know what to say but, i know you guys can help me
thank you very much
|
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.