Re: Replacing blank cells

[Ryan Pavlik <abiryan ryand net>]

How about inserting a column, and =IF(ISBLANK(A1), "NA", A1) in B1, 
assuming your data is A1?
You could then copy and "Paste Values" to remove the conditionals if you 
want.

Ryan
Steve Schwartz wrote:
> On Wed, 2007-08-15 at 13:39 -0400, Uri David Akavia wrote:
>   
> > What about doing replace
> > Value to replace: (just leave blank)
> > Replace with: NA
> >     
>
> This was my thought to, but gnumeric complains that "Search string must
> not be empty" I tried various alternatives with regular expressions, but
> without any success.
>
> Actually, my first thought was to save the file as a csv text file, and
> then open it in a text editor (or use sed) to replace:
>
>
> ^,
> ,,
> ,$
>
> (i.e., a comma at the beginning of a line, a pair of commas with nothing
> inbetween, and a comma at the end of a line) by
>
> "NA",
> ,"NA",
> ,"NA"
>
> respectively. This, of course, loses any formatting and formulae, but
> should work.
>
> HTH
>
> Steve
>
>   


--
Ryan Pavlik
AbiWord Win32 Platform Maintainer, Art Lead: www.abisource.com
AbiWord Community Outreach Project: www.cleardefinition.com/oss/abi/blog/

"Optimism is the father that leads to achievement."
-- Helen Keller

"The folder structure in a modern Linux distribution such as Ubuntu
was largely inspired by the original UNIX foundations that were
created by men with large beards and sensible jumpers."
-- Jono Bacon, The Ubuntu Guide