data spans multiple rows within each cell is collapsed when FILTER is used

U

unk1911

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?
 

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

Similar Threads

How to filter rows data based on background color of individual cells 3
Excel data filter collapses rows even after I select show all!?!?!? 4
What is the maximum filter for rows? 1
Checkbox issue - Checkbox overlapping when filter is applied 1
Filter for "blanks" in multiple columns simultaneously 2
Pivot table data layout - columns to rows 1
Data filter and deleting rows in visual basic 0
Autofilter Not working completely 2

Top