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
