Thread: [Solved] Sorting 2 or more words
View Single Post
 
Old 03-17-2017, 04:48 AM
Vertigo Vertigo is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Mar 2017
Posts: 1
Vertigo is on a distinguished road
Default 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!
Reply With Quote