Hello,

I have this sheet with a very(!) long list that looks something like this
(it has 2 columns only):

Col A | Col B |
Pears | 10 |
Apples | (blank) |
Oranges | (blank) |
Grapes | 5 |
Peaches | (blank) |
Bananas | 13 |

I need to copy only the Non Blank Cells into another sheet so that I get this:

Col A | Col B |
Pears | 10 |
Grapes | 5 |
Bananas | 13 |

How can I do this?


(Note: I posted this question also in Excel Worksheet Functions)

--
igor