Sort with Alpha numeric data

[Inactive User]

How to sort alpha-numeric data as ascending order.

Data like- 

ABC-101

ABC-105

ABC-40

ABC-100

[Inactive User]

How to sort alpha-numeric data as ascending order.

Data like- 

ABC-101

ABC-105

ABC-40

ABC-100

[grazitti_sapna]

Hi @Inactive User , if your data is similar to the one you posted in the post then you can try this solution.

Thanks.

[JosephSerpis · Accepted solution]

Hi @Inactive User I mocked up an example that use Regex. Let me know what you think?

[Inactive User · Accepted solution]

Thanks Its working fine with using Regex tool.