On Sun, Dec 21, 2008 at 12:03 PM, Sean Burns <[email protected]> wrote: > > I have over 7500 rows in a spreadsheet and need to find any empty > cells. So I thought I do a Find and Replace. I selected the A > ... > That bites.
Workaround: 1) insert a new column before A, so A becomes B 2) fill new column A with a numerical series, e.g. 1..7500, Edit > Fill > Series 3) select your data range, including column A, and sort on column B, Data > Sort. Blanks will be at the bottom (or top) of column B. Do what you want with those entries. When you are finished ... 4) sort on column A 5) remove column A, so B becomes A again. Regards, - Robert --~--~---------~--~----~------------~-------~--~----~ Central West End Linux Users Group (via Google Groups) Main page: http://www.cwelug.org To post: [email protected] To subscribe: [email protected] To unsubscribe: [email protected] More options: http://groups.google.com/group/cwelug -~----------~----~----~----~------~----~------~--~---
