Copy & Paste Non Blanks Only


I

Igorin

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)
 
Ad

Advertisements

M

Mike H

Then why don't you look in worksheet functions and feed back to the
respondents whether their solutions worked
 
Ad

Advertisements

I

Igorin

Mike,

I posted both at the same time, i.e. before I got an answer on the functions
forum. And the only reason I posted it here also was that I thought that the
functions forum was not the right one.

besides. Mike, there really is no need to give me that attitude. I mentioned
that I had posted it in the other forum because once I read that you guys
appreciate it when told if this questions was posted elsewhere.

Thanks for the "help"!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top