Hi,

I'm creating a list of assemblies. I want to be able to
list all the parts in one cell if possible and to still be
able to use them with the filter.

At the top of the sheet i have frozen the column titles
and added an auto filter so the user is able to search
each column.

Clear as mud?

I'm sure just entering 'A0123 A0234' would do the job but
it seems a bit...well, lame. Any better ideas remembering
i dont want to use more than 1 cell?

To give you some idea there are 160+ assemblies and each
has about 5 parts.

cheers