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.

Replace single 0 without affecting other cells
 

Select all the columns where you want to replace the zeros. The select Edit
Replace. Put a 0 in the 'Find what' field, and leave the 'Replace with'
field empty. Click the 'Options ' button and put a check in the 'Match
entire cell contents' box. Then click 'Replace all'.

Hope this helps,

Hutch

"Cindy E" wrote:

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.