| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I find and replace null values in Excel 2002 worksheets?
In case anyone is interested, F5SpecialBlanks only picks up true blanks but not null strings (="") returned by formulae.
I enter ="" into a blank cell, and it is not replaced by 0. Epinn "Gord Dibben" <gorddibbATshawDOTca wrote in message ... F5SpecialBlanksOK Type 0 in active cell then hit CTRL + ENTER Gord Dibben MS Excel MVP On Thu, 26 Oct 2006 16:37:02 -0700, Peter wrote: I have thousands of empty cells which I would like to replace with zeros, but opening Find and Replace, clearing the Find field and entering 0 in the Replace field replaces zeros in larger numbers I don't want edited. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find and replace should work in Excel text boxes | Excel Discussion (Misc queries) | |||
| find and replace path name in Excel cells containing hyperlink | Excel Discussion (Misc queries) | |||
| Can I find and replace "white space" in a cell in Excel? | Excel Worksheet Functions | |||
| Find and replace Excel, Office pro 2003 | Excel Discussion (Misc queries) | |||
| macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
Threaded Mode
