I need to find a way to define a pattern so I can write VBA code to take the column of requirement ID's and have them "custom sorted." From research, it appears that using RegEx patterns in VBA Code is the only way of solving this sorting issue. REGEX SORT NEEDED.xlsxThe problem is that some of the ID's generate a scheme that excel does not recognize as a number that can be treated as a value and then sorted. As an example, the list could look something like this:

UC501.9
UC501.9.1.2.1
ACR111-2
ACR111-2.1
ACR111-2.1.1.1
BSD0175 - 2
BSD017 -2.1.1.1
CO124 -1.2.1

So as you can see, I have to be able to handle discrepancies in entering requirements with "space" or no space before and after the dash and have to define a pattern for 2 and 3 alpha followed by 3 digits and a ".", a "-" where there could be a space before or after the "dash." And the tricky part comes in to having the subranges of numbers. I need the resulting code to work when the list of requirements is filtered by a scope ID vs a requirement ID. Sample attached.

Thanks,
Hank