Thread: Formula Question
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default Formula Question
In your final worksheet use, IF(ISNUMBER(A1),A1,""), or
IF(ISERROR(A1),"",A1). ed

Reply With QuoteReply With Quote