| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy & Paste Non Blanks Only
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? -- igor |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy & Paste Non Blanks Only
Click on Data-Filter-Auto Filter
Pick NON BLANKS from the drop down for the second col Copy the filtered rows and paste where you want. "Igorin" wrote: 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? -- igor |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy & Paste Non Blanks Only
Thank you!
-- igor "Sheeloo" wrote: Click on Data-Filter-Auto Filter Pick NON BLANKS from the drop down for the second col Copy the filtered rows and paste where you want. "Igorin" wrote: 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? -- igor |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy & Paste Non Blanks Only
Filter your list (Auto Filter). There should be an option (No Blanks), select
that option, and it should do the trick. Or us Custom filter and set a criteria like doesn't equal " ". h.t.h. -- when u change the way u look @ things, the things u look at change. "Igorin" wrote: 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? -- igor |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Copy & Paste Non Blanks Only
Thank you!
-- igor "sahafi" wrote: Filter your list (Auto Filter). There should be an option (No Blanks), select that option, and it should do the trick. Or us Custom filter and set a criteria like doesn't equal " ". h.t.h. -- when u change the way u look @ things, the things u look at change. "Igorin" wrote: 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? -- igor |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & Paste Non Blanks Only | Excel Discussion (Misc queries) | |||
| copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
| paste formula and skip blanks | Excel Discussion (Misc queries) | |||
| Paste Special - Skip Blanks | Excel Discussion (Misc queries) | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Hybrid Mode
