Ken Stephens wrote: > 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 >> >> > Just wondering instead of placing a '.', why not place 'NA', then paste > as prescribed. > > Ken > When I did my test, I did use NA instead of . and it worked fine Regards Fred James
_______________________________________________ PLUG mailing list [email protected] http://lists.pdxlinux.org/mailman/listinfo/plug
