View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
SteveW SteveW is offline
external usenet poster
 
Posts: 427
Default clear all zero-length strings from spreadsheet?

Not for me !

So you must have some sort of custom format on the cell


Steve

On Wed, 21 Feb 2007 14:11:06 -0000, Matt D Francis
wrote:

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.

??