Home |
Search |
Today's Posts |
#1
|
|||
|
|||
blank data field shows quote in formula, how to delete it?
In a data file I just received, many blank fields show a single-quotation
mark in the formula. The <<if statement does not recognize these fields as blank. I have tried to 'find and replace' the marks using a search for <<' and also for <<~' both without success. How can I fix these fields, in bulk, so they behave like blanks? |
#3
|
|||
|
|||
Those cells may have contained empty strings ( "" ), that were copied,
and pasted as values. This leaves a remnant in the cell, that is displayed as a apostrophe, when you turn on ToolsOptions, Transition tab, Transition Navigation. To clear the cells, you can try the Edit/Replace technique that Dave Peterson describes he http://groups.google.ca/groups?&thre...B8F0%40msn.com wdanner wrote: In a data file I just received, many blank fields show a single-quotation mark in the formula. The <<if statement does not recognize these fields as blank. I have tried to 'find and replace' the marks using a search for <<' and also for <<~' both without success. How can I fix these fields, in bulk, so they behave like blanks? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Custom format that shows blank cell if another cell is empty | Excel Discussion (Misc queries) | |||
Howdo U copy a formula down a column, that uses data in another w. | Excel Worksheet Functions | |||
Help with formula to make cell blank | Excel Worksheet Functions | |||
matching data formula? | Excel Worksheet Functions | |||
Formula to Extract Data from a Table | Excel Worksheet Functions |