On Mon, 21 Mar 2011, Fred James wrote: > Obviously there is the "type it in answer" ... but maybe that's not what your > are looking for?
Fred, Not when there are dozens of such empty cells on the page. > Are you looking for something in the "Find and Replace" arena? Or are you > asking a logic question? Or something else entirely? I have several dozens of client spreadsheets (all Excel, of course) with about 30 years' worth of compliance monitoring data. Different operators over the years and absolutely no standards for data organization or page structure. Or anything else. To import these data into postgres for statistical analyses with R I need to code missing values (blank cells) as NA (not available). I could do this after exporting the page as a .csv file, but wondered if there was a way to have the search field in "Find & Replace" blank the way we can have the replace field blank to remove cruft. Thanks, Rich _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
