Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
changing the width of a cell without affecting cells above or belo | Excel Discussion (Misc queries) | |||
Copy&paste cells w/o affecting borders | Excel Discussion (Misc queries) | |||
Removing leading single quote (') from cells with Search/Replace | Excel Discussion (Misc queries) | |||
How do I adjust cell widths without it affecting the cells above | Excel Discussion (Misc queries) | |||
Data Validation List Option Affecting Other Cells? | Excel Worksheet Functions |