Using a function to delete blank cells
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
|