Replace single 0 without affecting other cells

  • Thread starter Thread starter Cindy E
  • Start date Start date
C

Cindy E

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.
 
Select all the columns where you want to replace the zeros. The select Editfield empty. Click the 'Options >>' button and put a check in the 'Match
entire cell contents' box. Then click 'Replace all'.

Hope this helps,

Hutch
 
Back
Top