Subtracting data when copied from a IE screen

  • Thread starter Thread starter Pam
  • Start date Start date
P

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