Rich Shepard wrote: > On Mon, 21 Mar 2011, Roderick A. Anderson wrote: > > >> Another is to turn the problem on its head. Lets say the last cell of your >> sheet is E345. (You can find this by doing a CTL+END). Create a new sheet >> put "." in A1 and copy the cell. In the range selection box (that's the >> one next to f(x)) type A1:E345 and hit enter. Now hit CTL-V and paste. You >> have now A1:E345 filled with dots. Now go the the original CSV download. >> CTL-END then CTL-SHIFT_HOME to select the entire contents; copy it and >> toggle over to the new dotty sheet. Now do a Space Special (CTL-SHIFT-V) >> and check the "Skip Empty Cells" box. Job done. I know its a manual >> exercise but it only takes 15 secs or so. >> >> Replace the '.' (dot) with NA. >> > Thanks, Rod. > > Rich > _______________________________________________ > PLUG mailing list > [email protected] > http://lists.pdxlinux.org/mailman/listinfo/plug > > Just wondering instead of placing a '.', why not place 'NA', then paste as prescribed.
Ken _______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
