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.
|