Subtracting data when copied from a IE screen

[Pam]

I've copied/pasted numbers from a screen to excel. The data represents hours
in xx.yy format. I am trying to subtract 2 cells, but get an error. I
determined that the cells have extra spaces so I used clean(). I still get
an error when subtracting. I tested the cell with isText(clean()) -- and it
indicates it is TRUE. So I tried Value(clean()) and Value gives #VALUE
error. Please help

 

[Luke M]

If you call up the XL help file on CLEAN, you'll see that it doesn't
actually remove all non-prinatable characters. The most common one from the
internet is CHAR(160). You might try:

=VALUE(SUBSTITUTE(A2,CHAR(160),""))

 

[Gary''s Student]

Try:
=VALUE(SUBSTITUTE(CLEAN(E21),CHAR(160),""))