I have a list in Excel for example 1 2 3 .... 99, 100 then after 100 I have values like 100/1 100/2...100/10..100/20
Excel sort formula is working up to 100 but after that the sorting is like 100/1 100/10 100/11... 100/2 100/21
I want the / (divide) sign values sorting should be like 100/1...