| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Condense out blanks in a list
Say I have a list like the following:
Red Blue Green (blank cell) Yellow (blank cell) Orange (blank cell) (blank cell) Brown Is there a function I can use (not a filter) that will create a new list with blanks removed: Red Blue Green Yellow Orange Brown Any ideas? Thanks, Matt |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Condense list (remove blanks) | Excel Worksheet Functions | |||
| clearing blanks in drop-down list | Excel Discussion (Misc queries) | |||
| How do I sort a list that contains blanks that I want to keep? | Excel Discussion (Misc queries) | |||
| Vetical Filling blanks in a list | Excel Discussion (Misc queries) | |||
| validation list blanks | Excel Worksheet Functions | |||
Threaded Mode
