| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
data spans multiple rows within each cell is collapsed when FILTER is used
i have multi-row data in my cells. however, when i apply a filter on the column, the multi-row data is collapsed and appears as one long string. one idea i had was to append a single space after each data element before the carriage return. this works in solving the filter issue but it creates another issue, namely that i now have spaces after my data elements... this could be an issue for someone trying to cut/paste the data out. is there a more graceful solution?
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rows collapsed as subsets of other rows | Excel Discussion (Misc queries) | |||
| Indirect a range that spans multiple sheets | Excel Worksheet Functions | |||
| Combine data that spans two rows, preserving cells? | Excel Discussion (Misc queries) | |||
| Individual record spans multiple rows | Excel Worksheet Functions | |||
| how do I expand collapsed rows in excel | Excel Worksheet Functions | |||
Linear Mode
