View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Cindy E Cindy E is offline
external usenet poster
 
Posts: 6
Default Replace single 0 without affecting other cells

Is there a way to replace cells with just a 0, but not affect other cells. I
exporting data with tons of columns, including phone numbers, fax, etc. In
the cells that don't have a real phone number, etc., it imported as a single
0. I would rather not have to filter every column to delete these.

Thanks.