Hi
Formula approach for a couple of unwanted characters.
1: =TRIM(A1)
2: =TRIM(SUBSTITUTE(A1,CHAR(160),""))
3: =SUBSTITUTE(SUBSTITUTE(A1,CHAR(32),""),CHAR(160)," ")
Kevin
Quote:
Originally Posted by Ricky Martin
I have a problem, how to remove the spaces before and after the figure number.
two days I've searched but have not found the answer.
thank you
ricky
|