Thread: Subtracting data when copied from a IE screen
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default Subtracting data when copied from a IE screen
Try:
=VALUE(SUBSTITUTE(CLEAN(E21),CHAR(160),""))

--
Gary''s Student - gsnu201001
Reply With QuoteReply With Quote