Select the cells that may have the "" in them and use

Dim myCell As Range
For Each myCell In Selection
If myCell.Value = "" Then myCell.Value = ""
Next myCell


Note that this will remove formulas that return "" You could use this to prevent deleting
formulas:

Dim myCell As Range
For Each myCell In Selection
If Not myCell.HasFormula Then
If myCell.Value = "" Then myCell.Value = ""
End If
Next myCell

HTH,
Bernie
MS Excel MVP


"excel guru" <excel wrote in message
...
My problem is with converting an empty text back to a blank cell. "" IS NOT A
BLANK CELL BUT AN EMPTY TEXT.if a cell is "" then isblank will be false