View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Carter Devereaux Carter Devereaux is offline
external usenet poster
 
Posts: 1
Default 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