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 _______________________________________________ gnumeric-list mailing list gnumeric-list@gnome.org http://mail.gnome.org/mailman/listinfo/gnumeric-list
