Subtracting data when copied from a IE screen
 

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

Subtracting data when copied from a IE screen
 

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),""))

--
Best Regards,

Luke M
"Pam" wrote in message
...
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

Subtracting data when copied from a IE screen
 

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

--
Gary''s Student - gsnu201001