a Function can't but a Macro can
so if u realy mean that every Row's where column B is empty is deleted then
try this:

Sub CleanUp()
Range("B1:B2000").SpecialCells(xlCellTypeBlanks).E ntireRow.Delete
End Sub


"Carter Devereaux" skrev:

Hi,

I hope I ask this in the right way: I have 4 column, 2,000 row sprdsht. I
want to instruct Excel to look in column B, and if any column is blank, then
delete it. In other words, out of all the records, I only want to see the
ones that have text in col B. Does anyone know of a formula/function that can
do that, or can you point me in the right direction?

Thanks,
Brian