Custom Order Sort with Comma(,) as Criteria

Hi,

I need a custom order sort and it work fine if the criteria to be sorted does not contains comma (,)

Please Login or Register  to view this content.

However, when I have the following criteria, it does not work. This is because comma is used to segregate between these criteria. can anyone help me?
BC, HEAD
Head, Biz Dev.
Deputy Head
SBDM
SRM
BDM

You could temporarily replace the commas in the data with bars |
Then sort on the criteria that also has Bars | instead of commas
Then restore the commas in the data after the sort.

Please Login or Register  to view this content.