Sorting 2 or more words
Hello folks!
I'm working on a large excel sheet (for articles categorization work) and one of the columns I defined is "Field".
Under "Field", there are several fields to choose from (for instance: PV, CSP, etc').
I have some articles that need be tagged with 2 fields (for instance: PV and CSP).
If I write "PV + CSP" in the cell under the "Field" column, and use the Sort option in Excel, a new category will be added to the list - "PV + CSP". That's what I don't want to happen.
So my question is: can I write 2 (or more) words, that won't create a new sub-category in the Sort list? In my aforementioned example, I want the user to find that article by sorting with PV and CSP tags, seperately.
Thanks!
|