View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Matt D Francis Matt D Francis is offline
external usenet poster
 
Posts: 13
Default clear all zero-length strings from spreadsheet?

Hi, I want a quick way of clearing all zero-length strings from a spreadsheet

I tried using Find & Replace

Find: ""
Replace: (left blank)

But it put zeroes in instead of actuall deleting all contents.

??